Collect (Sumif xxx)
Hi, I have following challenge ;-)
my sheet:
reason costs
reason1 x €
reason2 y €
reason3 z €
how can I calculate in a formula how much Costs are depending on various reasons?
Best Answer
-
=sumif(Reason:Reason, @cell = "Reason 1",Amount:Amount), then just change Reason 1 to Reason 2 etc.. for each condition.
Answers
-
=sumif(Reason:Reason, @cell = "Reason 1",Amount:Amount), then just change Reason 1 to Reason 2 etc.. for each condition.
-
How would you use this formula, to add another sumif statement?
My sheet says something like:
Labor Rate/hr Subtotals
Fabrication $45 $45
Fabrication $45 $45
Design Work $45 $45
Fabrication $65 $65 <- Here there was a rate change
IF the Labor is Fabrication, and IF the rate was at $45/hr, I want to add up those subtotals.
-
It looks like you created a post about this and were answered here: https://community.smartsheet.com/discussion/70135/nested-sumif-formulas-across-multiple-sheets#latest
Let us know if you still have questions!
Cheers,
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!