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
|