G'day guys,
Long time listener, first time caller.

I'm trying to find a formula that will count the number of times an 'item' is beding used within the same date range.
- this is essentially the same thing as Resource Usage in Microsoft Project, but I need it in Excel.

This is what I have thus far:
A B C D
1 Item Number Start Date Finish Date Calculation
2 A1152 2/01/2014 12/01/2014 =COUNTIFS(A:A,A1,B:B,">="&B2,C:C,"<="&C2)
3 A1152 1/01/2014 11/01/2014
4 B2263 2/01/2014 12/01/2014
5 B2263 1/01/2014 11/01/2014
6 A1152 3/01/2014 13/01/2014


The result should be '3', given that the same 'Item' is being used 3 times withing the same timeframe (for Item Number A1152).

Any assistance would be greatly appreciated, as I've been stuck on this for Days!!

Cheers
Steve