=SUMPRODUCT(--(C2:C200="Bid"),--(G2:G200="Sold"))

etc.

Note, SUMPRODUCT uses explicit ranges, not whole columns.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"AJB" wrote in message
...
In column C, I have a lead source, ie Bid, Yellow Pages, Website etc. In
column G, I have Sold, Open, Lost. I have tried to come up with a nestled
function that counts the instances of sold in column G for each source in
C,
but with no luck. Any help?

thanks much,

Andy