SUMIFS

Allison Crull

I am trying to create a SUMIFS formula and having issues.

I would like to get the SUM by Segmentation:

Total SUM of Annual REV If Segmentation is 'Diamond'

Total SUM of Annual REV if Segmentation is 'Gold'

Total SUM of Annual REV if Segmentation is 'Silver'

Smartsheet Communicaty-SUMIFS.docx

hollyconradsmith

Hi @Allison Crull

Try =SUMIF([Annual rev]:[annual rev], segmentation:segmentation, segmentation@row)

Alternatively, if this is for reporting purposes, you could create a report and use the Group and Summary functionality.

Group by Segmentation

Summary Sum of Annual Rev.

Allison Crull

This is returning a "incorrect argument set"-any other suggestions for a formula?

Allison Crull

I tried this formula and I am getting 0 return

=SUMIF({Look Up Table Range 1}, MATCH([Primary Column]@row, {Metadata Range 1}, 0))

Allison Crull

@hollyconradsmith any other suggestions?

Allison Crull