# Formula for filtering multiple columns to get an expense total

edited 11/08/23

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

• ✭✭✭✭✭✭

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!