This worked great thank you !!!!. can you by any chance email me to let me
know how it works. I have never used this feature before. sarrasin@vianet.
ca

T. Valko wrote:
Try this:

=SUMPRODUCT(--(C1:C10="Tom"),--(G1:G10="Red"))

Better to use cells to hold the criteria:

A1 = Tom
A2 = Red

=SUMPRODUCT(--(C1:C10=A1),--(G1:G10=A2))

Note that you can't use entire column references unless you're using Excel
2007.

Biff

I am using a countif to cout how many times something is appearing in a
column. I need a code that does a dual column count. example: if column
c
says tom then go to column g and count if it says red.

Any help is greatly appreciated.