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