Pulling data from different sheet that meets given criteria

JRose

Hi-- I am aware that I can select cells X1 - X50, for example, to reflect their sum on a different sheet. 

But in my case I am looking to automatically calculate sales on a separate sheet. So, out of a given list of prospects, I wish to pull figures only from those entries that have a checkbox associated with a sale in a given column. How can I calculate just those figures on my separate sheet?

Thanks!

Andrée Starå

Hi,

Try this:

=SUMIF({Sale Range}; 1; ({Sum Range}))

Depending on your country you’ll need to exchange the semi-colon to a comma in the above formula.

Please see the attached link/screenshot for more information.

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

https://help.smartsheet.com/function/sumif

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

JRose

Forgive me, this is returning "#UNPARSEABLE".

My formula is: =SUMIF({{{{Rainbow_2018 Range 2}}}}, 1, ({{{{Rainbow_2018 Range 3}}}}))

where the first range represents a checkbox column and the second range represents a column containing numeric values.

I have tried with comma and semicolon, and have also tried selecting specific cells (rather than entire column) to see if this might work, to no avail. 

Thank you--

 

Andrée Starå

Try this:

=SUMIF({Rainbow_2018 Range 2}, 1, ({Rainbow_2018 Range 3}))

You had to many curly braces it seems.

JRose

You da man.

Andrée Starå

Thank you! Glad that we got it fixed.

Paul Newcome

Out of curiosity... What is the purpose of the extra () wrapped around the second range? I've never seen it done that way.

J. Craig Williams

It has no function.

 

Andrée Starå

No purpose, just a mistake 

Paul Newcome

10-4. Just making sure I hadn't missed something. You know Smartsheet and their sometimes not so smart ideas...