SUMIFS statement


I am trying to use SUMIFS to pull reference a numbers on another sheet.

I want to say if the PO number is = X, pull the invoice total from the invoice total column and Sum it in this column on another sheet. (So I can see a sum of total put to that PO number).

Any help would be appreciated!

Thank you!


  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭

    Try this:

    Assumption: PO Number and Invoice Total columns are in Sheet 1 and your formula is used in Sheet 2

    =SUMIF({PO Number Column Range from Sheet 1}, "X", {Invoice Total Column Range from Sheet 1})

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!