Countifs + AND/OR functions
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
Comments
-
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.
Help Article Resources
Categories
Check out the Formula Handbook template!