# A count on 2 criteria, 2nd is a date range

October 26, 2010 at 13:14:01
Specs: Windows XP
 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.

See More: A count on 2 criteria, 2nd is a date range

#1
October 26, 2010 at 17:32:22
 Thanks for letting us know what you need.If you need some help with that, feel free to ask.

Report •

#2
October 27, 2010 at 06:48:26
 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/10E26 Contains the date 2/1/10F26 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.ThanksA.

Report •

#3
October 28, 2010 at 06:37:32
 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.

Report •

Related Solutions