Countifs + AND/OR functions

Jose Iguiniz

Hi, 

 

I'm trying to create a table to display via a dashboard that shows project status in three categories: Complete, in progress, other. Other includes 3 different values that i need to group into that "other" category.

How do you smart folks recommend i do this. I've tried a bunch of things but i get invalid #INVALID DATA TYPE. my line for the straight forward categories is below.

=COUNTIFS({SDU Project Map V2 Range 6}, "Q1", {SDU Project Map V2 Range 9}, "In progress", {SDU Project Map V2 Range 7}, "2018-19")

Much appreciated

 

Jose

 

 

Paul Newcome

Can you give us a screenshot with an example of each category plus an example of each of your 3 values in the Other category?

By reading your post it seems relatively straightforward, but I want to make sure I'm not reading anything wrong.