SUMIF when one column is blank

PDunn

I want to SUM autototal # only when customer exclusive is blank and the studio = xyz and the market year is 2024

These formulas below don't work. I can't get the formula to exclude the rows that are customer exclusives from my total. I get incorrect argument or unparseable anyway I try to write it.

=IF(ISBLANK({custexclus}, <>"", SUMIFS({autototal}, {Studio}, Description@row, {Mktyrs}, "2024")))

=IF(ISBLANK({custexclus}, SUMIFS({autototal}, {Studio}, Description@row, {Mktyrs}, "2024")))

RickyT

You might have some luck using the IFERROR function in there, Im not sure syntactically how that fits into your formula but here are the docs for the function. https://help.smartsheet.com/function/iferror