Formula Issues

joe.afusco

Board Regular
Joined
Jun 25, 2010
Messages
80
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)>​
 
Last edited:

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

pagrender

Well-known Member
Joined
Sep 3, 2008
Messages
652
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

Board Regular
Joined
Jun 25, 2010
Messages
80
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..
 

Forum statistics

Threads
1,136,797
Messages
5,677,789
Members
419,720
Latest member
kurman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top