Is there a formula that allows to count rows from different sheets for one total?


My team usually builds calculation sheets with formulas referencing other sheets for dashboards. We need to show a total for the year adding current data plus archive which are 2 different sheets but, on a row-by-row basis.

Best Answer

  • Ryan Sides
    Ryan Sides ✭✭✭✭✭✭
    Answer ✓

    Hi @Wen H.

    Yes! Just combine your CountIfs with a plus sign + like this...

    =COUNTIFS({Sheet 1 Range}, FIND(Model@row, @cell) > 0) + COUNTIFS({Sheet 2 Range}, FIND(Model@row, @cell) > 0) + COUNTIFS({Sheet 3 Range}, FIND(Model@row, @cell) > 0)

    Does that help?


    Ryan Sides

    Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube

    Come Say Hello!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!