Creating metric formula for referenced sheet

Katkss

Good morning, I'm trying to sum a total estimate based on approval status for specific months/year. This is my formula:

=SUMIF({Totals FDC Status}, [Primary Column]@row, {R&R Total Estimate}, {R&R by month}, "8", {R&R by Year}, "2024")

Unfortunately, I'm getting "incorrect argument". I did ask AI but they do not reference other sheets yet. Can anyone help?

Thanks much 😊

Kerry St. Thomas

You're super close. When you are trying to get a sum based on MULTIPLE criteria, you'd use SUMIFS (plural). Based on the formula references above, I think you'll want to go with something similar to this (though I'm not sure if I have assumed correctly which range is for which thing) -

=SUMIFS({R&R Total Estimate}, {Totals FDC Status}, [Primary Column]@row, {R&R by month}, "8", {R&R by Year}, "2024")

The first item is what you're summing up; the rest are the criteria RANGE and criteria VALUE that you'd use. More on SUMIFS here:
https://help.smartsheet.com/function/sumifs

Good luck!

Katkss

Thank you Kerry, I will give it a go. Much Thanks.

Kathy