Problem with Sumifs formula

[DRB207]

Hi All,

I tried to use the sumifs formula horizontally with 2 criteria's. The criteria's are Location (Named as T1,N1,O1,T2 & T3) & Month (Apr'22 to Jun'22). I have attached the excel file for your reference. 3 sheets are there in the excel (named as Summary, 1 & 2). I am trying to get the values from Sheet 1 & 2 to summary by using sumifs function. The formula is working only for the location T1. If I change the location as N1 or others the formula is not working.

=SUMIFS('1'!$42:$42,'1'!$1:$1,Summary!C3,'1'!$3:$3,"T1") - Working
=SUMIFS('1'!$42:$42,'1'!$1:$1,Summary!H3,'1'!$3:$3,"N1") - Not displaying the values in summary.

Please help asap.

Thanks in advance

[AliGW]

Please help asap.

Welcome to the forum.

Please don't put pressure of time on a community where help is given for FREE by unpaid volunteers. Thank you.

[TMS]

That would be because the date is only in cell D1. You have used Centre Across so it looks pretty but you can't easily use the date I just the one cell. Pretty, yes. Practical, no.