Excel Formula count

[thifu3]

Hi guys,

Could you please help me on this.

john 25,
doe 26,
john 35,
bon 28,
john 35.

how do i calculate the total amount of john?

 

[kchiba]

Hi thifu3,

you can SUMIF()

 

[kchiba]

here is a file with an example

 

[Xiq]

Hi thifu3,

There is the exotic way and the practical way. Both have multiple solutions. But let me ask you: is it possible to keep the data separate in your workbook? If so, then I suggest you do so.
The next step would be something like this:

=COUNTIF(A:A,"John")

 

[Hui]

=SUMPRODUCT(--(A4:A9="John"),B4:B9)
or
=SUM((A4:A9="John")*B4:B9) Ctrl+Shift+Enter

 

[thifu3]

Wow. Chandoo org is the best. Thank you all for giving prompt and wonderful answers.

 

[jahangeer100]

The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.