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