View Single Post
  #1   Report Post  
Brian
 
Posts: n/a
Default 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