How can I sum values using SumIfs condition like ...

[LearnerExcel]

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.

[xor]

If your headings start in A1 then put this formula in C2 and copy down:

=IF(COUNTIF($B$2:B2,B2)=1,SUMIF($B$2:$B$20,B2,$C$2 :$C$20),"")


(For another time please remember that the actual Excel file with data is much more helpful than a picture).

[LearnerExcel]

Originally Posted by xor

If your headings start in A1 then put this formula in C2 and copy down:

=IF(COUNTIF($B$2:B2,B2)=1,SUMIF($B$2:$B$20,B2,$C$2 :$C$20),"")


(For another time please remember that the actual Excel file with data is much more helpful than a picture).

It doesn't show any result. I might be doing something wrong. Please help.

[xor]

See the attached.

[LearnerExcel]

Great sir. You saved my a lot of time since I have hundreds of records to edit.

[LearnerExcel]

How can I make this post "Solved"? I don't see any option here.

[xor]

I am not sure "how to make this post Solved". Maybe an Administrator could step in here?