SUMIF when one column is blank

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!