Previous Topic Next Topic

Formula

Closed
ladyhawk1956 Posts 1 Registration date Thursday September 19, 2013 Status Member Last seen September 19, 2013 - Sep 19, 2013 at 11:50 AM
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Sep 19, 2013 at 02:07 PM
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 response

Answer 1 / 1
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 9
Sep 19, 2013 at 02:07 PM
Hi ladyhawk1956

Perhaps the COUNTIF function.

=COUNTIF(B:B,"H")

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses