Hey y'all!
Here's what I have so far:
=SUMIF({GRAD Student - Support Request Range Complete Date}, AND(<=DATE(2019, 5, 9), >=DATE(2019, 1, 7)), {GRAD Student - Support Request Time Spent Range})
Complete Date = the date range I'm trying to pull from
After the "And"= The range I want for the dates.
Time Spent = The location of the data I want to be totaled.
When I put this formula in, I get an Invalid Operation error. Any help would be appreciated.
EDIT: Figured it out by myself.
Should've been using the SUMIFS formula.
My final formula is as such:
=SUMIFS({GRAD Student - Support Request Time Spent Range}, {GRAD Student - Support Request Range Complete Date}, >=DATE(2019, 1, 7), {GRAD Student - Support Request Range Complete Date}, <=DATE(2019, 5, 9))