Total Amount of Rejections Created Last Week
Help!!!! I can't figure out where the problem is with my formula. I am trying to write a formula to calculate the total $ amount of rejections from last week. This is what I have. It comes up with an Incorrect Arugument.
@Paul Newcome can you help?, please...... 😀
=IF(WEEKNUMBER(TODAY()) = 1, SUMIFS({Rejection Tracker Total Billed A/R}, IFERROR(WEEKNUMBER(@cell), 0) = 52, {Rejection Tracker Date Added to Report}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1), SUMIFS({Rejection Tracker Total Billed A/R}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()) - 1, {Rejection Tracker Date Added to Report}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())))
Best Answer
-
It is with your SUMIFS statements.
You have:
=SUMIFS(range, criteria, range, criteria)
You SHOULD have:
=SUMIFS(range to sum, range, criteria, range, criteria)
Answers
-
It is with your SUMIFS statements.
You have:
=SUMIFS(range, criteria, range, criteria)
You SHOULD have:
=SUMIFS(range to sum, range, criteria, range, criteria)
-
@Paul Newcome OMG you are wonderful, I was sitting here racking my brain. All fixed! You did it again! It's Friday, I need to give my brain a rest! Thank you again!!!
-
Help Article Resources
Categories
Check out the Formula Handbook template!