why does ON = Ambiguous in substitution formula?
 

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

One way:

for your column total:

=COUNTIF(B2:B10,"ON")

for your row total


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

In article ,
waladd wrote:

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

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

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


Regards,

Peo Sjoblom

"waladd" wrote:


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

still only showing formula

"waladd" wrote:

still only showing formula

nevermind got it

Thank you very much