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

Options

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 ✓
    Options

    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

    Ryan Sides

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

    Come Say Hello!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!