Formula Issues

[joe.afusco]

I have 3 columns that I am trying to collect data on. I am currently using SUMIFS to check the amount of rows that meet the criteria I want.

My first two rows, the sumif works. It is written like this:

=SUMIFS(Sheet1!D:D,Sheet1!A:A,"MATCH",Sheet1!B:B,"TRUE")

This should return 1, which it does. I am trying to get it to filter a 3rd column which is a date value. When I modify this formula for a date earlier than 90 Days before today, I put :

=SUMIFS(Sheet1!D:D,Sheet1!A:A,"MATCH",Sheet1!B:B,"TRUE",Sheet1!C:C,<today(-90)><today(-90))><today(-90)><TODAY(-90)

I know this isn't correct, because it isn't working. I just don't know what to adjust.


</today(-90)></today(-90))></today(-90)>​

 

[pagrender]

I'm sure someone will be able to do this with one formula... but unfortunately I'm not that person!

I can do this if you make a "helper" column. In column E, if you put the following formula and drag it down:
=TODAY()-C1

Then, this formula should work:
=SUMIFS(Sheet1!D:D,Sheet1!A:A,"MATCH",Sheet1!B:B,"TRUE",Sheet1!E:E,"<90")

 

[joe.afusco]

Thank you for the input.

I am attempting to do this with many date ranges.. Earlier than 90 Days ago, between 60 and 90 days ago, 30 and 60, today and 30 days ago, etc..

 

[joe.afusco]

actually, that seems to be working well! Thank you!