View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ba374 ba374 is offline
external usenet poster
 
Posts: 3
Default Count based on criteria from two different columns

Hello,

I am sure this is a simple formula but for the life of me I can not remember.

Here is my scenario:

Column C (c6:c70) contains the data "won" or "lost"
Column F (f6:f70) contains the data "4wd loaders" "backhoes", etc.

I need to count, in another column, how many backhoes were lost and so on.

Thanks,
Brandy