View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
C00l C00l is offline
external usenet poster
 
Posts: 1
Default Counting 2 different pieces of data in 2 different columns

I try t he same thing but it doesn't work and gives me #NUM!

I want to count the entries from that satifies bothe conditions
b1 from column B and c1 from column c

Thanks

"Cindyt" wrote:

Thanks - worked great!

"T. Valko" wrote:

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