COUNT IF - Multiple Columns


I am trying to use countif based on multiple columns for a calculation sheet for my dashboard.

I am trying to compile a calculation based on the "site name' and if the items for that site are overdue or not.

For example: I want to pull from these two columns below into my calculation sheet

So how would I set that up in here to have it show the items that are overdue based on site ?


  • J Tech
    J Tech ✭✭✭✭✭

    Hi @tchav

    You can use the COUNTIFS function to count the number of items that are overdue for each site. Here's an example formula:

    =COUNTIFS({Original Sheet Range 1}, "Overdue", {Original Sheet Range 2}, "Site Name 1")

    Replace "Original Sheet Range 1" with the range of the column containing the overdue status (e.g. "Overdue" or "On Track"). Replace "Original Sheet Range 2" with the range of the column containing the site names. Replace "Site Name 1" with the name of the site you want to count the overdue items for.


    J Tech

    If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!