Conditional sum formula
Please be gentle, very novice smartsheet user!
I am trying to get a total value on a smart sheet when certain conditions are met.
I have a column called Type and a column called value, so when cell entries in column type are a particular value, I want a sum of the values recorded against that type in column value. And I only want this between rows 2 and rows 18. The formulas I've tried are:
=SUMIF(Type2:Type:18, Product, Value2:Value18)
=SUMIF(Type2:Type:18,"Product", ([Value2:Value18])
=SUMIF(Type2:Type:18,"Product"; [Value2:Value18])
But I just keep getting unparseable errors :-(
I've added a separate column to store the values in and set the column properties to number/text.
I'm sure its just a really rookie error but I can't figure it out for the life of me.
Comments
-
Hi Ian,
Here is the formula so that you can easily copy it.
=SUMIF(Type2:Type18; "Product"; (Value2:Value18))
Please also see attached link/screenshot.
I hope this helps you!
Have a fantastic weekend!
Best,
Andrée Starå - Workflow Consultant / Get Done
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Kaboom! all good :-)
Happy me and happy MD..
Thank you :-)
-
Happy to help and your welcome!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!