Multiple SUMIFS Statements across sheets


I'm seeking some assistance to draw data from multiple sheets, based on a number of criterion.

I'm looking to return a value based on two criterion in two different sheets to a third sheet.

Basically, IF "Yes" appears in the Payment Certificate Helper Column of this sheet (Payment Register), I need to then look up the associated Contract Number - in this case 1, in the Contract Register.

Payment Register

Contract Register

After identifying Contract Number 1, I need the formula to return Contract Sum (in this case - $0.50) to the third sheet.

Thanks for your assistance.



Best Answer


  • Richard Heath
    Richard Heath ✭✭✭✭✭✭

    Hi Genevieve,

    Thanks for the amazing response!

    I ended up inputting a helper cells into my Metric Sheet that looks up the Contract Number based on "Yes" in the Payment Register then running a second formula to look up the returned Contract Number value and looking up my Contract Register - so two separate formulas instead of one - no big deal.

    Thanks for taking the time to detail the INDEX MATCH alternative.

  • Genevieve P.
    Genevieve P. Employee Admin

    No problem at all! Glad that you were able to find something that works for you 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!