Two columns match calculate columns

Eddie Endurium LLC

Eddie Endurium LLC ✭✭✭✭

06/22/23 in Formulas and Functions

I am trying to sum from a separate sheet if Columns A and Column B equal criteria sum Column C... but having problems.

0 ·

Best Answer

Paul Newcome ✭✭✭✭✭✭

06/22/23 Answer ✓

You would use a SUMIFS.

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

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
1 · Share on Facebook Share on Twitter

Answers

Paul Newcome ✭✭✭✭✭✭

06/22/23 Answer ✓

You would use a SUMIFS.

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

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
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 Automation
I'm trying to create an automation (alert someone) when a specific cell in my sheet is greater than or equal to $1,500. Right now, when I try to create an automation, my only available triggers are: When a date is reached When rows are added or changed When rows are changed When rows are added I need a trigger for "When a…
Formula Consolidation
This was originally a checkbox column to see if an estimated was within a 10% margin on either side, but now I need it to account for if it is under/over the 10%. Currently, three checkbox columns exist, with the following formulas: EST GOOD - =IF(AND([HR PER UNIT / EST]@row > [10% DOWN]@row, [HR PER UNIT / EST]@row < [10%…
SUMIF sum of the number of cells meeting a text condition
I'd like to add up the number of boxes with the same condition. For example, in column 1 I would like to count how many times I have the word nature. When I use SUMIF to do this it doesn't works.