|Could some one please help me with the formula for this problem?|
I need to count the result based on 2 criteria.
The first criteria looks for a name match and the second criteria looks for a match within a set date range, eg. the month of Feb.
The source data for the name match is in column B from B2:B1000.
The data for the date is in column C from C2:C1000.
E22 Contains the date 2/1/10
E26 Contains the date 2/1/10
F26 Contains the date 2/28/10
This is the formula I have been trying to use but haven't be able to make work.
I'm sure the problem has to do with E22 and the way I am trying to discribe the range but after trying numerious combinations and expressions I'm still not able to get it to solve.
On a seperate sheet I was able to successfully use the following formula
to give a TRUE or FALSE answer. Column B was reduced down to 1 or 0 for the name match and column D was the dates.
I could use this to solve my problem but I wouild wind up with an incredibly large sheet of data to cover the 12 months and the 20 names for which I need to pull data. This doesn't seem at all practical especially when it seems possible to reduce it all down to 1 line of formula if I can just get it right.
Any assistance would be greatly appreciated.