If I understand what you want...

=SUMPRODUCT(--(A1:A10="auto quote"),--(B1:B10="sold"))

Better to use cells to hold the criteria...

D1 = auto quote
E1 = sold

=SUMPRODUCT(--(A1:A10=D1),--(B1:B10=E1))

--
Biff
Microsoft Excel MVP


"Cindyt" wrote in message
...
Hi -

This should be so simple - but I can't figure it out

I need to do a countif in one column to count, for example, # of "auto
quotes" and in another column count the number of "sold" that corresponds
to
the first column. Ideally, I could figure the percentage along with it,
but
if not, I can always do that in a separate cell.

Thanks for any help!
Cindyt