Solved how does microsoft excel add charecters in a column

February 18, 2015 at 21:51:37
Specs: Windows 8
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 z

so 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


See More: how does microsoft excel add charecters in a column

Report •


#1
February 19, 2015 at 06:35:49
✔ Best Answer
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

http://www.skeptic.com/

message edited by mmcconaghy


Report •
Related Solutions


Ask Question