Using countifs formula

Shane Cornwell

Hello,

I have used the COUNTIFS formula successfully in the past when pulling the status and date off a workspace. An example of the formula used is below:

=COUNTIFS({Corrigo Work Orders Range 1}, "Closed", {Corrigo Work Orders Range 2}, AND(@cell >= DATE(2020, 4, 1), @cell <= DATE(2020, 6, 30)))

However, I now need to be able to pull the same information as above, except I need to incorporate the name of the person who worked the task order. Is there a way I can easily add that into my existing formula or am I way off base? Any help would be greatly appreciated.

Thanks

Genevieve P.

Hi @Shane Cornwell

You can just continue on the COUNTIFS statement by adding another Range and then Criteria... for example:

=COUNTIFS{Corrigo Work Orders Range 1}, "Closed", {Corrigo Work Orders Range 2}, AND(@cell >= DATE(2020, 4, 1), @cell <= DATE(2020, 6, 30)), {Corrigo Work Orders Range 3}, "Person's Name")

Here I presumed the column where people are listed would be called {Corrigo Work Orders Range 3}. If you have set up your destination sheet with these calculations to have the people listed down one column, then instead of typing their name in the formula manually each time, you can use a cell reference, like so:

=COUNTIFS{Corrigo Work Orders Range 1}, "Closed", {Corrigo Work Orders Range 2}, AND(@cell >= DATE(2020, 4, 1), @cell <= DATE(2020, 6, 30)), {Corrigo Work Orders Range 3}, [Person's Name]@row)

Let me know if you have any questions about this!

Cheers,

Genevieve

Genevieve P.

Hi @Shane Cornwell

You can just continue on the COUNTIFS statement by adding another Range and then Criteria... for example:

=COUNTIFS{Corrigo Work Orders Range 1}, "Closed", {Corrigo Work Orders Range 2}, AND(@cell >= DATE(2020, 4, 1), @cell <= DATE(2020, 6, 30)), {Corrigo Work Orders Range 3}, "Person's Name")

Here I presumed the column where people are listed would be called {Corrigo Work Orders Range 3}. If you have set up your destination sheet with these calculations to have the people listed down one column, then instead of typing their name in the formula manually each time, you can use a cell reference, like so:

=COUNTIFS{Corrigo Work Orders Range 1}, "Closed", {Corrigo Work Orders Range 2}, AND(@cell >= DATE(2020, 4, 1), @cell <= DATE(2020, 6, 30)), {Corrigo Work Orders Range 3}, [Person's Name]@row)

Let me know if you have any questions about this!

Cheers,

Genevieve

Shane Cornwell

The best solution is usually the simplest... lol 😊

Thank you greatly for the help, that did the trick. I appreciate the help on this one.

Thanks!!

Genevieve P.

Great! So glad it worked for you 🙂