Thread: Need vba code/formula

Hi All,

I have two columns Item in column A and Price in Column B. Item in column A gets repeated and i want a vba code/formula in column C which sums the price in column B

Please refer the attachments for more info

Hello
Copy the following formula down column C. This should do what you're looking for.

=SUMIF($A$2:$A$6,A2,$B$2:$B$6)

Originally Posted by DBY

Hello
Copy the following formula down column C. This should do what you're looking for.

=SUMIF($A$2:$A$6,A2,$B$2:$B$6)

Awesome...Thanks a lot..