PRODUCT SUM with ITEMCODES

[sealpino]

I want to accumulate item values with certain codes.
Each line has an item code for example 4000.
Each line has a value. I want to add those!

[oeldere]

with a pivot table.

see the attached file.

[oeldere]

H14 = 3000


Solution 2)

H15 =sumproduct(($d$4:$d$9=h$14)*($c$4:$c$9))


Solution 3)

H17 =SUMIF($D$4:$D$9,H$14,$C$4:$C$9)

[Punnam]

Please Login or Register  to view this content.

in h3 and use Ctrl+Shift+Enter drag it to right

Please Login or Register  to view this content.

in H3 and drag it to right

Punnam

[sealpino]

U are my hero, i am looking more at PIVOT now
Still Learning.

[oeldere]

@sealpino

Since you got answers of several forummembers it is good to add to whom you replying.