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.

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

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