Hello all
I'm looking for a little help with a formula I'm working on
<colgroup><col width="64" style="width:48pt" span="18"> </colgroup><tbody>
</tbody>
I'm using formula to get C1 is =SUMPRODUCT(($J$5:$J$11=C$15)*($K$4:$R$4=$B16)*(K$5:K$11))
But when I copy the formula to the other cell, the result don't match
to make the the results is match, I have to make a formula in each cell
is there a formula that fits my problem, so I only need to make 1 formula only without change the data ?
Any help would be gratefully received
Thank You
<colgroup></colgroup><colgroup><col width="64" style="width:48pt"></colgroup><tbody>
</tbody>
I'm looking for a little help with a formula I'm working on
Date July | |||||||||||||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | ||||||||||
Colour | Blue | 213 | 231 | 921 | 324 | 213 | 743 | 423 | 752 | ||||||||
Yellow | 446 | 113 | 521 | 546 | 456 | 654 | 351 | 328 | |||||||||
Red | 133 | 132 | 279 | 218 | 248 | 249 | 249 | 965 | |||||||||
Orange | 453 | 218 | 418 | 246 | 231 | 321 | 278 | 453 | |||||||||
Blue | 123 | 234 | 385 | 673 | 236 | 218 | 235 | 238 | |||||||||
Purple | 485 | 135 | 215 | 846 | 745 | 896 | 923 | 789 | |||||||||
Red | 346 | 486 | 856 | 134 | 876 | 123 | 465 | 742 | |||||||||
Colour | |||||||||||||||||
Blue | Yellow | Red | Orange | Purple | |||||||||||||
Date July | 1 | 336 | |||||||||||||||
2 | |||||||||||||||||
3 | |||||||||||||||||
4 | |||||||||||||||||
5 | |||||||||||||||||
6 | |||||||||||||||||
7 | |||||||||||||||||
8 |
<colgroup><col width="64" style="width:48pt" span="18"> </colgroup><tbody>
</tbody>
I'm using formula to get C1 is =SUMPRODUCT(($J$5:$J$11=C$15)*($K$4:$R$4=$B16)*(K$5:K$11))
But when I copy the formula to the other cell, the result don't match
to make the the results is match, I have to make a formula in each cell
is there a formula that fits my problem, so I only need to make 1 formula only without change the data ?
Any help would be gratefully received
Thank You
<colgroup><col width="64" style="width:48pt"></colgroup><tbody> </tbody> |
<colgroup></colgroup><colgroup><col width="64" style="width:48pt"></colgroup><tbody>
</tbody>