Help With This Formula ....

Yes Bob, The Idea is to create a formula that would check if there is a Phone Number (E6:E35) First, and if that is true then Check for the Left Conditions (G6:G35) if that condition is true then Count or (Sum Values) ..

But a Blank in E Cells (No Phone Number), then NO Count or (Summing of Values).. Thanks In Advance..

I also appear to have a problem when I tried to use Not Equal "<>" commands the returns will not work properly. Is this because of the "--" or the formula script itself...

eg.

This Returns Good Values:
=SUMPRODUCT(--('DAY1'!E6:E35<>0),--(LEFT('DAY1'!G6:G35,2)=""))+SUMPRODUCT(--(LEFT('DAY1'!G6:G35,1)="/"))

Phone Number Cells Not Blank, G Cells = Blank, Left Character G Cell = "/" These Conditions works well to return a count..
-------------------------------------------------------------
This Returns bad Values: (Bad meaning incorrect for the conditions tested)

=SUMPRODUCT(--('DAY1'!E6:E35<>0),--(LEFT('DAY1'!G6:G35,2)<>"GI"))+SUMPRODUCT(--(LEFT('DAY1'!G6:G35,1)<>"M"))

Phone Number Cell Not Blank, Left Function of G Cells <> "GI" or "M"
This Formula Doesn't Return accurate Results.

thanks for checking this out...