text calculations (1 Viewer)

[andrewleith1]

Hi,
i was wondering how to do the following...
for example im making a workplanner and i would like to put an "h" in the cells where i am going to be on holiday.
i would like "h" to equal 1. how would i go about calculating the "h"s???
i hope you understand!
thanks
andrew

 

[SMatthews]

You could use the countif() function. You can have it count the number of times "h" is in the defined range. i.e. =COUNTIF(A1:G10, "H")

 

[andrewleith1]

Thanks for your help! got it working!