That's an AND not an OR

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Bondi" wrote in message
ups.com...

Mhz wrote:
HELLO,

For some reason I keep getting a "TOO FEW ARGUMENTS" error with this
formula:

=COUNTIF(OR('DAY1'!E6:E35<"",LEFT('DAY1'!G6:G35,2 )<"GI"))

I am simply trying to use a count if 2 conditions are met... 1. if
Fields E6:E35 is not empty and 2. Fields G6:G35 Left 2 Characters <
"GI" then count.

But The formula is not being accepted as I have it above...

Any help here is much appreciated... Thanks In Advance


--
Mhz
------------------------------------------------------------------------
Mhz's Profile:
http://www.excelforum.com/member.php...o&userid=35980
View this thread:
http://www.excelforum.com/showthread...hreadid=564648

Hi,

Maybe you can use SUMPRODUCT(). Something along the lines of:

=SUMPRODUCT(--(E6:E35<0),--(LEFT(G6:G35,2)<"GI"))

Regards,
Bondi