SUMIF Rollup

[hadassi82]

I would like to sum values from a certain math column based on a common value in a template column I have.

Example:

I have endless values in the template column, so I cannot create an IF-THEN-ELSE column for each value I have.
What is the easiest way to create this?

[Darren_Murphy]

Use a Query column and apply a filter, then do a rollup through the query.

[hadassi82]

Can you please elaborate?
I am not able to get what I need…

[Darren_Murphy]

Well, the Query column negates the need for Template columns in such cases, so you can ignore that.

Step by step:

• Add a Query column, target it at the same table, and apply the following filters:
  – First Name is This row->First Name
  – Last Name is This row->Last Name
• Now add a Rolllup column, target it at the Query column, and select Sum->Price.

If you don’t see the sum option in the rollup, check and make sure that your Price column is a number type.

[hadassi82]

Thank you very much for the explanation, but something does not work…

This is what I do:

This is what I got for the query:

And as the query returns the name value - I cannot create a rollup based on it:

What am I missing here?

[Darren_Murphy]

[hadassi82]

Perfect! Thank you!!