Function for complex count

Hi all,

I would like to count some values in Excel. But it's not to simple because I have to columns like this

A B
a 1
b 1
a 2
c 1
a 1

I need that the function count the 'a' characters and add to the result the numbers of column 'B', so finally, the result would be this, for value 'a':

4

Is there any function for it?

Thanks

Perhaps this if you are trying to sum all of the numbers together in column B when the corresponding row in column A has the letter "A" in it. Based on your post and the total being 4, I am guessing that is what you want.

=SUMIF(A1:A10,"A",B1:B10)

Hope that helps.

Adjust the range as necessary.

Thank you,

I tried SUMIF, and it's working correcty!