Pulling data from different sheet that meets given criteria
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?