sumproduct formula
I get to a certain point and I just can't figure stuff out.
I have this formula:
=SUMPRODUCT(--(ISNUMBER(-LEFT('Patrol Log'!H10:H13,1))))
This is to count cells that have data beginning with a number, however there
is one piece of text that I want included in the sum. "switch". How can I
get this text included in the sum?
Thank You
Brian
|