SUMIFs, SUMPRODUCT, and INDIRECT

[lilsaint01]

Good Day,

I am trying to solve this issue, but I didn't find any mistake in the formula.
Could someone please help me check or correct the formula?
Thank you

You can check the file in this link: TEST FORMULA.xlsx

???

 

[jasonb75]

Perhaps if you provided some kind of clue as to what you need then you might get some help.

The majority of helpers on the forum are not able to download attached files, so a thread with no question will likely get no answer.

 

[lilsaint01]

I am not good at explaining since my English is not that good.
So I will upload the picture instead.

What I'm trying to do is to calculate column E base on code on column A.
Before this, I did the same formula on the other file and it worked, but no for this file, so I want to know why this formula is not working here.

Sorry for the bad quality of the picture

 

[jasonb75]

Try SUMIF instead of SUMIFS

The syntax of the 2 differs slightly, to use SUMIFS the criteria, $A2 would need to be after the second INDIRECT(), not before.

 

[lilsaint01]

I did as you said,

But the formula still not working.

However, I did the same calculation in another file and its working.

 

[Bo_Ry]

PRICE & CODE LIST
M2
Add space behind ="PI.001-20 "

M12
Remove End ="PI.013-20"

Total
C4
=SUMPRODUCT(SUMIF(INDIRECT("'"&JAN_Order[JAN]&"'!A16:A89"),$A4,INDIRECT("'"&JAN_Order[JAN]&"'!E16:E89")))

 

[lilsaint01]

Dear Sir @Bo_Ry Thank you so much, I didn't realize there such a mistake in the file but you found it.

I fix it and the formula working perfectly. Thank you.