LaurenHancy
Board Regular
- Joined
- Aug 5, 2010
- Messages
- 179
Hi All,
Hope you are having a great Tuesday. I desperately need your help.
I need to count the number of red cells (data range in colour C2:JC2) per person depending on the the following criteria:
Name = Collum A
By Month, Jan, Feb etc = Row C1:YC1 (MM/DD/YYYY)
"Lates" = Collum B
B34 is the *red* cell referance
I have the following formula already but I cant seem to add the other criteria into this formula. It works but I have to select which cells to count for each name and month. There are many names to contend with.
=CountCellsByColor('Daily Call KPI''s'!$C$2:$JC$2,$B34)
<tbody>
</tbody>
Thank you for you help.
L xx
Hope you are having a great Tuesday. I desperately need your help.
I need to count the number of red cells (data range in colour C2:JC2) per person depending on the the following criteria:
Name = Collum A
By Month, Jan, Feb etc = Row C1:YC1 (MM/DD/YYYY)
"Lates" = Collum B
B34 is the *red* cell referance
I have the following formula already but I cant seem to add the other criteria into this formula. It works but I have to select which cells to count for each name and month. There are many names to contend with.
=CountCellsByColor('Daily Call KPI''s'!$C$2:$JC$2,$B34)
A | B | C | D | E | F | G | |
1 | 01-Jan | 02-Jan | 03-Jan | 04-Jan | 05-Jan | ||
2 | David | availibility | *Red* | *Green* | *Green* | *Green* | *Green* |
3 | Lates | *Green* | *Green* | *Green* | *Red* | ||
4 | Kelly | availibility | *Green* | *Red* | *Green* | *Green* | *Green* |
5 | Lates | *Green* | *Red* | *Green* | |||
6 | Jane | availibility | *Green* | *Green* | *Green* | *Green* | *Green* |
7 | Lates | *Green* | *Green* | *Green* | *Green* |
<tbody>
</tbody>
Thank you for you help.
L xx
Last edited: