How do I create a formula that covers two sheets ?

Hi,

I currently have this formula in use and I'd like to include one more sheet. How do I do that? Thank you!


=COUNTIF({Master Data - National (Atten how did you hear)}, Label14)

Tags:

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Hi Irina,

    If I'm understanding what you want to do the answer is to add additional COUNTIF statements. Along the lines of:

    =COUNTIF({Master Data - National (Atten how did you hear)}, Label14) + COUNTIF({2nd sheet range}, Label14) + COUNTIF(3rd sheet range}, Label14)

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!