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)>
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: