Hi,

How can I sum values using SumIfs condition to get the values like in the attached image file? For multiple records with same PRD NO., it should calculate the total Amount but put it in a related first cell of "Total" column and the other cells with same repeated PRD. NOs. should be blank in last column ("Total").

I am not able to put my question clearly but the image file can explain more.

Looking forward to your support.



Note: Multiple PRD. Nos. are highlighted.

Attached Images

Excel_Question.PNG (60.5 KB, 25 views)