If/And formulas
Maria Watters
✭✭✭✭✭
Hello All,
I am trying to create a formula where I want to see the sum of all positive test results if the testing date is within the last week.
This is what I have so far and not sure if I am even on the right track.
=SUMIF(AND({Employee Surveillance Testing Range 1}, >0, {Employee Surveillance Testing Range 4} - TODAY() - 7))
Tags:
Best Answer
-
Try something like this...
=SUMIFS({Range To Sum}, {Range To Sum}, @cell > 0, {Date Range}, @cell >= TODAY(-7))
Answers
-
Try something like this...
=SUMIFS({Range To Sum}, {Range To Sum}, @cell > 0, {Date Range}, @cell >= TODAY(-7))
-
Thank you!