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. Som...
With names
=SUM( COUNTIFS( NamesRange, name, StatusRange, {"in progress","not started"} ) )
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"} ) )- this work perfectly and it's easy to use. thank you so much!
You are welcome
=SUMPRODUCT(($B$5:$B$18=E5)*($C$5:$C$18={"not started","in progress"}))An alternative could be SUMPRODUCT.
