How to count values depending on date data

[juntjoo]

So as you can see in the first column I have a count of things(mailings) that have an associated entry date and to the right I'm trying to create an ongoing count of the numbers under column A BUT dependent on the entry date (i.e. since last 7, 30, 90 days). Obviously SUM is the obvious solution for the "all time" count but now throwing in relative(to the associated entry date) conditions is where I'm stuck. How would we do this? Something along the lines of 'count column value under A so long as cell to right is within so many days of today'. Thanks

[José Augusto]

Hi
Replace D1 E1 and F1 by 7 30 and 90.
Try this in D2 and copy forward

Please Login or Register  to view this content.

[juntjoo]

Thanks. I'm trying to backwards engineer this now. How did you figure out the table number to put i front of its name like that? Or didn't you and when you selected the table/range excel put that i there? Thanks!


Actually, I found this elsewhere =SUMIF($B:$B,">="&TODAY()-7,$A:$A) which also works but is much shorter. What is the extra code in yours for?

[José Augusto]

Hi

There is no extra code. My formula is valid to 7, 30 and 90 days.
Short? A:A has 1048576 rows.