why does ON = Ambiguous in substitution formula?

W

waladd

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
 
J

JE McGimpsey

One way:

for your column total:

=COUNTIF(B2:B10,"ON")

for your row total


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

waladd

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
 
P

Peo Sjoblom

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


Regards,

Peo Sjoblom
 
Top