How to write formula to add few columns in a row from selected rows


How to write formula in another sheet referencing this sheet to add few columns in a row for selected rows ? for example, sum all electricity for all sites e.g. Aizu, Belgium, Bucheon...etc for Q1 (Jan, Feb and Mar). THANKS!


  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 01/28/21

    Hi @Lynna

    Hope you are fine, i solved this issue for you in my previous post, please recheck Cross sheet Formula.

    =SUMIFS({SPI Data Total}, {SPI Data Site}, Site@row, {SPI Data Parameter}, Parameters@row)

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!