TRANSPOSE the RESULT

[zelga]

Hello all
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>

 

[FormR]

Hi, welcome to the forum,

You could try like this:

=SUMIFS(INDEX($K$5:$R$11,0,MATCH($B16,$K$4:$R$4,0)),$J$5:$J$11,C$15)

 

[zelga]

wow , it works
thany you very much @FormR