why does ON = Ambiguous in substitution formula?

[Guest]

trying to set up a schedule for work to calculate how many people are on,
where ON = 1 in the columns below but equals 7.5 (hours) in the rows going
right

 

[JE McGimpsey]

One way:

for your column total:

=COUNTIF(B2:B10,"ON")

for your row total


=COUNTIF(B2:H2,"ON")*7.5

 

[Guest]

I am only seeing the formula not the result on the following formula:
=COUNTIF(B2:B10,"ON")

other formula worked fine, when I click the function button it shows the
result in a pop-up window but not on spreedsheet

Thank you for your help

 

[Guest]

Format cell as general and double click the cell and press enter, you have
probably text format


Regards,

Peo Sjoblom

 

[Guest]

still only showing formula

 

[Guest]

still only showing formula

nevermind got it

Thank you very much