Hi!

Try this:

=SUMPRODUCT(--(C1:C100=690),--(D1:D100="green"))

Better:

A1 = 690
B1 = green

=SUMPRODUCT(--(C1:C100=A1),--(D1:D100=B1))

Biff

"imjustme" wrote in
message ...

Problem:

I need to be able to do a multiple count if stmnt. Ex:

if column c = 690 and column d = green

thanks
D


--
imjustme
------------------------------------------------------------------------
imjustme's Profile:
http://www.excelforum.com/member.php...o&userid=26854
View this thread: http://www.excelforum.com/showthread...hreadid=400959