Formula required

[A_SIRAT]

Good day,

Please assist with a formula. I have explained in the attached file.

[#2]

@A_SIRAT 

[#3]

@A_SIRAT 

=SUMPRODUCT(($C$1:$F$1=J$1)*($A$2:$A$7=$I2)*$C$2:$F$7)

You can try SUMPRODUCT.
 

[#4]

Thank you.

Could you do it with SUMIFS ?

[#5 · Accepted solution]

@A_SIRAT That would be:

=SUMIFS($C2:$F2,$C$1:$F$1,J$1)

But why SUMIFS if you only have one criterion?

[#6]

Thank you.

Because I wanted to know where I got it wrong. It can also help in future when I have more than one criterion.
Sorry I learnt SUMIFS first and prefers it

[#7]

Thank you for the SUMPRODUCT alternative.

[#8]

@A_SIRAT 

I learnt SUMIF() first, but prefer always to use SUMIFS() since it has more logical sequence of parameters.