Help on Sumif Formula with Relative & Absolute reference

[Nandakumar]

Hi,

I need formula help on the attached excel sheet where rows & columns are large.

I want to fix the sumif formula with $ sign to fix one formula instead of changing each rows?

Please note that rows A to G in sheet1 will be as sheet2.

Thanks in advance.

Regards,

 

[Khalid NGO]

Hi Kumar,

Try this in Sheet1 C4:

=SUMPRODUCT((Sheet2!$D$2:$K$2=$B4)*(Sheet2!$A$3:$A$5=C$2&C$3)*(Sheet2!$D$3:$K$5))

Copy across and down.

Regards,

 

[Nandakumar]

Thank you so much ! It works