Formula

[Closed]
Report
Posts
1
Registration date
Thursday September 19, 2013
Status
Member
Last seen
September 19, 2013
-
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
-
Can someone please help me? I have a column with the letter H and I would like to add a value to the H so that I can sum the colum in the last row. i.e.

If Column B contains
H
H
H
H

Total would be 4

1 reply

Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Hi ladyhawk1956

Perhaps the COUNTIF function.

=COUNTIF(B:B,"H")

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!