SUMIFS Help

BryceDim

I am trying to sum a column with SUMIFs. I have two sets of criteria but am having trouble with the third. I am trying to sum the cost if it matches a project title column, and invoiced quarter column. If the invoice quarter column is blank I want to check if a different column (expected delivery quarter) matches.

The formula I tried is the following

=SUMIFS({Cost}, {Spending Group}, Name@row , {Invoice Quarter}, "Q1 - 2025", IF(ISBLANK({Invoice Quarter}), {Expected Delivery Quarter}), "Q1 - 2025")

I am getting an incorrect argument error.

Is this possible?

AdamSYNH

https://community.smartsheet.com/discussion/comment/488088#Comment_488088

No worries at all, in that case, you can do away with the IF portion and add together two SUMIFS, where one set of criteria includes the blanks in Invoice Quarter.

=SUMIFS({Cost}, {Spending group}, Name@row , {Expected Delivery Quarter}, "Q1 - 2025", {Invoice Quarter}, "") + SUMIFS({Cost}, {Spending group}, Name@row , {Invoice Quarter}, "Q1 - 2025")

AdamSYNH

Hi @BryceDim,

You need to switch to nesting your SUMIFS within an IF, rather than an IF within your SUMIFS. Try the below:

= IF(ISBLANK({Invoice Quarter}), SUMIFS({Cost}, {Spending Group}, Name@row, {Expected Delivery Quarter}, "Q1 - 2025"), SUMIFS({Cost}, {Spending Group}, Name@row , {Invoice Quarter}, "Q1 - 2025")

BryceDim

https://community.smartsheet.com/discussion/comment/488078#Comment_488078

Thanks Adam,

Good idea! Unfortunately I still have the incorrect argument set error showing up with this solution.

AdamSYNH

Sorry @BryceDim, I should have looked at the brackets. Are you referencing another sheet?

BryceDim

Hey @AdamSYNH yeah sorry I should have mentioned that. This formula is on a summary sheet pulling data from the sheet in my screenshot.

AdamSYNH

https://community.smartsheet.com/discussion/comment/488088#Comment_488088

No worries at all, in that case, you can do away with the IF portion and add together two SUMIFS, where one set of criteria includes the blanks in Invoice Quarter.

=SUMIFS({Cost}, {Spending group}, Name@row , {Expected Delivery Quarter}, "Q1 - 2025", {Invoice Quarter}, "") + SUMIFS({Cost}, {Spending group}, Name@row , {Invoice Quarter}, "Q1 - 2025")

BryceDim

https://community.smartsheet.com/discussion/comment/488092#Comment_488092

Cool! That worked! I didn't realize you could do that. Thanks for the help!