Pulling data from different sheet that meets given criteria

JRose
JRose
edited 12/09/19 in Smartsheet Basics

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!

Tags:

Comments