COUNT IF - Multiple Columns

tchav

Hello,

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

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.