i am trying to add up the number of times a character , letter of number in a column a b c d

1 s

2 s

3 e

4 zso i would like to add the number of s and e in column a1 to column a4 ( as a total n eg 3 )

please can you help

I think what your looking for is the COUNTIF() function, To count the number of the letter S and the letter E, in Column B

as per your example, you could do something like:=COUNTIF(B1:B4,"s")+COUNTIF(B1:B4,"e")

See how that works for you, and in the future Excel questions are best asked

in the Office Software Forum.MIKE

message edited by mmcconaghy

Ask Your Question

Weekly Poll

Do you think Salesforce should have bought Slack?

Discuss in The Lounge

Poll History