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

 

[The Stoat]

Hi

As an example if you enter a H into cell A2 and create this formula in another cell outside of the selected range A1:A3 - otherwise you get a circular reference error - it will count 1. Add another H to A3 and you'll get 2 and so on.

=COUNTIF(A1:A3,"H")

HTH

TS

 

[andrewleith1]

Thanks for your help! got it working!