Conditional sum formula

Ian Smith 2017

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.

Find more posts tagged with

Formulas

Comments

Andrée Starå

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

Image 2018-01-26 at 1.21.53 em.png

Ian Smith 2017

Kaboom! all good :-)

Happy me and happy MD..

Thank you :-)

Andrée Starå

Happy to help and your welcome!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?