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

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