Previous Topic Next Topic

Formula

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

Réponse 1 / 1
Kevin@Radstock Posts 42 Registration date Thursday 31 January 2013 Status Member Last seen 26 April 2014 9
19 Sep 2013 à 14:07
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
how to convert ounces (oz) to milliliter
JPortillo -
vcoolio -

1 response