Array Formula not working

[edwardpestian]

I have the following array formula that will not work for some reason.

{=SUM(IF(C4:C18="TRUE",IF(D418="19:00",1,0)))}

I have a checkbox over each cell in the range C4:C18. Each box is associated with the respected cell. So when a box is checked it returns TRUE, and of course, when its not checked it returns FALSE. It then looks in the range D418 for the time 19:00. And then sums each cell that meets the criteria. For some reason the formula does not like the TRUE value or the time value. If I change each value to a text string it works.

Any ideas?

ep

 

[GlennUK]

TRUE is not a string, in fact as it is a logical item you don't even have to test it that way. And times are not strings ...

=SUM(IF(C4:C18,IF(D4:D18=TIMEVALUE("19:00"),1,0)))

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.