Forum Discussion
Solved
Countifs + OR
Hi,
Honestly I don't know how to google it and I feel I'm losing it.
I'm trying to combine a COUNTIF function with OR.
I have 2 people, Mary and Jane and they have tasks to be completed. Some tasks are marked as "not started" and some tasks are marked as "in progress" (the others are done but it's not the concern here).
I want to use a formula so I can see how many tasks does each of them have not started or in progress.
So my table would be like this:
Mary / not started
Mary / in progress
Jane / done
Mary / done
Jane / in progress
Mary / in progress
How many tasks does Mary have not started OR in progress?
How many tasks does Jane have not started OR in progress?
Please. Help. Me.
With names
=SUM( COUNTIFS( NamesRange, name, StatusRange, {"in progress","not started"} ) )
6 Replies
- It doesn't fully work. This one just counts all the "in progress" and "not started". I need to count them but taking in consideration another cell/ range (the name, Mary or Jane)
With names
=SUM( COUNTIFS( NamesRange, name, StatusRange, {"in progress","not started"} ) )
