View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debbie Debbie is offline
external usenet poster
 
Posts: 90
Default count on multiple conditions

I'm trying to perform a count based on two columns and two conditions. I've
searched the forum and found several options but can't get any of them to
work. Will "countif" not work with date?

Here's what I'm doing:

A B
neutral 8/1/2006
positive 8/1/2006
negative 8/5/2006

I want to use a code that will search column b for a date: 8/1/2006 and
return a count of how many positives, negatives and neutrals I have within
that date.

Can anyone help?
Thanks,

Debbie