Hi gurus!
I would like to ask for your expertise on how I can resolve this issue of mine.
I would like to get the average of all the values under the R-E-D category on different locations.
I have tried using IF functions and SUBTOTAL but i am not getting the correct answer that i need.
Please help.
Thanks!
=IF(A1="North",SUBTOTAL(1,C8:C19,F8:F19,I8:I19),"")
Location:
R = SUBTOTAL(1,R1,R2,R3)
E = SUBTOTAL(1,E1,E2,E3)
D = SUBTOTAL(1,D1,D2,D3)
<tbody>
</tbody>
I would like to ask for your expertise on how I can resolve this issue of mine.
I would like to get the average of all the values under the R-E-D category on different locations.
I have tried using IF functions and SUBTOTAL but i am not getting the correct answer that i need.
Please help.
Thanks!
=IF(A1="North",SUBTOTAL(1,C8:C19,F8:F19,I8:I19),"")
Location:
R = SUBTOTAL(1,R1,R2,R3)
E = SUBTOTAL(1,E1,E2,E3)
D = SUBTOTAL(1,D1,D2,D3)
Agent Name | Location | R1 | E1 | D1 | R2 | E2 | D2 | R3 | E3 | D3 |
Agent1 | North | 92 | 75 | 55 | 92 | 87 | 97 | 77 | 89 | 66 |
Agent2 | East | 55 | 74 | 63 | 80 | 76 | 68 | 90 | 99 | 96 |
Agent3 | West | 74 | 96 | 60 | 94 | 59 | 63 | 87 | 86 | 95 |
Agent1 | South | 81 | 82 | 61 | 100 | 66 | 85 | 84 | 87 | 84 |
Agent2 | North | 77 | 90 | 83 | 72 | 85 | 89 | 83 | 93 | 85 |
Agent3 | East | 64 | 90 | 54 | 85 | 60 | 93 | 74 | 77 | 65 |
Agent1 | West | 67 | 90 | 66 | 63 | 60 | 88 | 97 | 60 | 68 |
Agent2 | South | 91 | 80 | 65 | 63 | 62 | 74 | 59 | 81 | 94 |
Agent3 | North | 79 | 84 | 73 | 98 | 66 | 92 | 93 | 79 | 50 |
Agent1 | East | 74 | 80 | 85 | 87 | 92 | 91 | 79 | 89 | 82 |
Agent2 | West | 80 | 80 | 53 | 76 | 72 | 80 | 83 | 78 | 87 |
Agent3 | South | 82 | 100 | 71 | 56 | 50 | 74 | 74 | 73 | 58 |
<tbody>
</tbody>