Multiple SUMIF Criteria formula results in #Incorrect Argument Set or #Unparcible.

LuminaVPSales

I do have one last question. Lets say that I want to select the paid date for just 2023 how do I add this to this formula? I do have a Paid Date column on the sheet as well.

KPH

Phew 😌

🥳

Can you mark the comment from 11:59AM as the answer. Everything after that was just understanding some features specific to your sheet. Anyone with a similar problem should find the answer they need in that comment.

You enjoy your day, you did it! 💃

KPH

For your follow up.

1. You have a formula that is summing the deal value where Inspection Type is a certain value, Contract Stage is one of two values. This is good.
2. You want to do something with Paid Date in 2023.

Is Paid Date a date column?

Do you still want to sum the deal value?

If so, you can add an additional range and criteria to your SUMIFS.

First you need a formula to find the year from your Paid Date.

Then you put this into the SUMIFS (after an extra comma).

Like this:

=SUMIFS([Deal Value]:[Deal Value], [Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract Stage]:[Contract Stage], OR(@cell = "7. Paid", @cell = "8. Commissioned"), [Paid Date]:[Paid Date], YEAR(@cell) = "2023")

LuminaVPSales

This is a HUGE help! Thank you so much for your assistance.

KPH

Happy to help @LuminaVPSales