#Invalid data type - Countifs on two category's.

Jason P

Hi, team.

Difficulty in nailing the formula..

Sourcing data from our Design sheet I'm trying to count for each of our sales team members how many requests they have lodged (10 requests types) & of those how many of them are at each status (7 types). IE, I could have 10 at Drawing only& of those 4 at "In Progress", 2 at "Not Started" etc. This data will feed to a dashboard.

Hope you can help

Regards

Jason

Andrée Starå

Hi @Jason P

You don’t need the AND part because the COUNTIFS function will only count when all the conditions are true.

Make sense?

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Jason P

You don’t need the AND part because the COUNTIFS function will only count when all the conditions are true.

Make sense?

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jason P

Hi @Andrée Starå

Mate worked a treat, I tried a few options - hey thanks so much for taking the time, I see many of your answers when I look for other solutions.

Andrée Starå

Excellent!

You're more than welcome!