Counting

[leimst]

I have a spread with Store #, Acct. #, and Date columns. I am looking for a way to look at the data in each row and count the number of times that particular Store #, and Acct. # combination occurs throughout the spreadsheet and within 5 days of the date shown in that row. I am familiar with the COUNTIFS function and as an example was using COUNTIFS(A$2:A$100,A2,B$2:B$100,B2,C$2:C$100,C2) where B is the Date column but don't know how to check a 5 day range of dates instead of just the single B2 date. Is this doable?

Thank you in advance for any help!

 

[baitmaster]

Welcome to the board. First rule, yes you can do almost any theoretical calculation with Excel. If you can think it, sooner or later you can write a formula / macro for it

For this, you should be able to use the following:

=COUNTIFS(A$2:A$100,A2,B$2:B$100,">="&B2,B$2:B$100,"<"&B2+5,C$2:C$100,C2)

 

[leimst]

Thanks, that worked like a charm!