Thread: COUNTIF - Two Criterian

I have a speadsheet in which i have some date in columns A-E

Basically

One row represents an order for each address


I have managed to come up with a formula which counts the number times a date within the last xx number of days occurs...

I.e. number of orders in the past 3, 5, 14 etc days

I also have areas, what i would like to do is now come up with a formula which will count the number of orders in the past 3 days for the areas...

i.e. the number of occurrences of a date when column D = xx.
- countif Column B = a date within the last 3 days and Column D = V1


Please see my post on

http://www.excelforum.com/excel-work...ml#post2591021

This seems to be not a million miles away, my problem is my data set includes formated dates.

Would a sample upload help?