Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Can we use countifs formula referencing two sheets having same column? How can we do it?

    ✭✭✭✭
    edited 07/11/23 in Formulas and Functions

    I have 2 sheets having month columns. One sheet runs on automation and whenever it is filled, the existing rows will move to archive sheet. Now, I want to count the rows in both the sheets having same month and display it in another metric sheet. I have used countif to achieve that, but it functions for either sheet.

    image.png

    I have tried using countifs and referencing both sheets. But I think we cannot reference two different sheets.

    I need help with the formula.

    · Share on FacebookShare on Twitter

    Best Answer

    • ✭✭✭✭✭✭
      Answer ✓

      Hey,


      I hope I understood correctly.

      You can use 2 countif formulas like that: =countif()+countif()

      Let me know if I missed your point.

      Itai Perez

      If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

      https://www.linkedin.com/in/itai-perez/

      · Share on FacebookShare on Twitter

    Answers

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions