Formula for filtering multiple columns to get an expense total

Angela Hollingsworth

NEVERMIND ;-)

Sometimes you figure it out 5 minutes after asking! lol

=SUMIFS(EXPENSE8:EXPENSE1915, [VENDOR PERSON]8:[VENDOR PERSON]1915, NOTES@row, ID8:ID1915, OR(@cell = "CAPACITY"))

Hello,

I have a formula I need to expand on to add another column of data to filter what I need.

Using this formula now to get an overall total:

=SUMIF([VENDOR PERSON]8:[VENDOR PERSON]1915, NOTES@row, EXPENSE8:EXPENSE1915)

I want to add the "ID" (drop-down type with 5 choices) column to help filter to one of five categories to change the total to only one of those categories.

I have tried variations of these so far:

=SUMIFS([VENDOR PERSON]8:[VENDOR PERSON]1915, ID8:ID1915, "RAD PODS", NOTES@row, EXPENSE8:EXPENSE1915)

=SUMIFS([VENDOR PERSON]8:[VENDOR PERSON]1915, ID8:ID1915, @cell = "RAD PODS", NOTES@row, EXPENSE8:EXPENSE1915)

Any help will be greatly appreciated!

Angela

jmyzk_cloudsmart_jp

Hi @Angela Hollingsworth

The syntax of the SUMIFS function is as follows;

SUMIFS( range , criterion_range1 , criterion1 [ criterion_range2​ , criterion2​... ])

• range — The group of cells to sum, assuming they meet all criteria.

So, add "S" to your existing formula's SUMIF, move the EXPENSE8:EXPENSE1915 to the top as the range to sum, then add the 2nd criterion_range and criterion, ID8:ID1915, "RAD PODS," at the bottom.

=SUMIFS(EXPENSE8:EXPENSE1915, [VENDOR PERSON]8:[VENDOR PERSON]1915, NOTES@row, ID8:ID1915, "RAD PODS")

https://help.smartsheet.com/function/sumifs