KuraiChikara
Board Regular
- Joined
- Nov 16, 2016
- Messages
- 111
- Office Version
- 2013
- Platform
- Windows
Hello, I'm trying to perform a countifs with multiple criteria but part of the multiple criteria is in the same column and I can't get the countifs to calculate properly.
I am trying to ask, "How many people work on this day of the week at this time?"
One start time and one day of the week I can calculate just fine:
Example:
=COUNTIFS($B$2:$B$5,"MO",$A$2:$A$5,A2)
This formula comes out to 4.
<tbody>
</tbody>
However, if I add an additional day of the week for a criteria, it gives me a zero.
=COUNTIFS($B$2:$B$5,"MO",$B$2:$B$5,"TU",$A$2:$A$5,A2)
I don't get why I'm getting zero. Should be 4.
<tbody>
</tbody>
I am trying to ask, "How many people work on this day of the week at this time?"
One start time and one day of the week I can calculate just fine:
Example:
=COUNTIFS($B$2:$B$5,"MO",$A$2:$A$5,A2)
This formula comes out to 4.
Start | Week |
6:30 AM | Mo |
6:30 AM | Mo |
6:30 AM | Mo |
6:30 AM | Mo |
<tbody>
</tbody>
However, if I add an additional day of the week for a criteria, it gives me a zero.
=COUNTIFS($B$2:$B$5,"MO",$B$2:$B$5,"TU",$A$2:$A$5,A2)
I don't get why I'm getting zero. Should be 4.
Start | Week |
6:30 AM | Mo |
6:30 AM | Mo |
6:30 AM | Tu |
6:30 AM | Tu |
<tbody>
</tbody>