How do you sum one colunm if it matches the criteria from two other columns

SharonR

SharonR ✭✭✭✭✭

05/03/20 in Formulas and Functions

Need help with this formula

I want to sum one colunm if it matches the criteria from two other columns

=SUMIFS({PO Form - Range 3}, {PO Form - Range 1, ="Proj:01",[{PO Form - Range 2} = "Stationary"}])

0 ·

Answers

Paul Newcome Community Champion

05/04/20

Try this...
=SUMIFS({PO Form - Range 3}, {PO Form - Range 1}, "Proj:01", {PO Form - Range 2}, "Stationary")

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
1 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Help with a checkbox triggering a formula
I have an order form that I'm creating. I have these three fields here in question. Item 1 (Checkbox) Item 1 Qty (Number Amount) Item 1 Price (Formulated box that when Item 1 is checked and they put 2 in the Qty, it multiplies it by the price of the item) I have written this formula and came up empty. Tried a few different…
How do I reduce cross-sheet references? My sheet tells me I have reached the max. number
How to copy a row with values not formulas
Hello, I have an automation on a sheet to copy a row to another sheet each day. The automation works. My issue is that it copies formulas and they all break and return errors. How can I copy a row but have it copy values instead of formulas? Below is the Automation This is the original sheet This is the sheet where it is…