In Excel, I need to do a count based on 2 criteria. Criteria 1 looks for A, criteria 2 looks to see if A falls with in a selected date range.

Thanks for letting us know what you need. If you need some help with that, feel free to

ask.

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/10This is the formula I have been trying to use but haven't be able to make work.

=COUNTIFS(B2:B1000,$E2,$C$2:$C$1000,E22>=E26<=F26)

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

=IF(B3=1*(D3>=40210),AND(D3<=40237))

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.

Thanks

A.

I figured it out myself =COUNTIFS($B$2:$B$1000,$E2,$C$2:$C$1000,">="&E$24,$C$2:$C$1000,"<="&E$25)

I would just like to thank DerbyDad03 without whom I never would have done this myself. Thanks! I will always remember to feel free to

ask.

Ask Your Question

Weekly Poll

Would you use augmented reality navigation apps?

Discuss in The Lounge

Poll History