Total Amount of Rejections Created Last Week

Pam Ferguson

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

Paul Newcome

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

It is with your SUMIFS statements.

You have:

=SUMIFS(range, criteria, range, criteria)

You SHOULD have:

=SUMIFS(range to sum, range, criteria, range, criteria)

Pam Ferguson

@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!!!

Paul Newcome

Happy to help! 👍️

Enjoy your weekend!