Thread: functions
View Single Post
  #1   Report Post  
Dawn S
 
Posts: n/a
Default functions

In column A are dates
In column B are values (1, 2, 3)
I want to look at A for a date greater than a specific date then match to B
for a specific number and count as 1 if they match

if A 11/30/04 and B = 1 then count as 1
If I have 5 rows that fit the criteria then the answer would be 5.

Please help with the formula, I have tried countif and nested in countif.

Thanks
Dawn