Try...

=SUMPRODUCT(--($C$1:$C$100=690),--($D$1:$D$100="Green"))

or

=SUMPRODUCT(--($C$1:$C$100=G1),--($D$1:$D$100=H1))

....where G1 contains your first criterion, such as 690, and H1 contains
your second criterion, such as Green. Adjust the range accordingly.

Hope this helps!

In article ,
imjustme
wrote:

Problem:

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

if column c = 690 and column d = green

thanks
D