LinkBack URL
About LinkBacks
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!
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!
with a pivot table.
see the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
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)
in h3 and use Ctrl+Shift+Enter drag it to rightFormula:
Please Login or Register to view this content.
in H3 and drag it to rightFormula:Please Login or Register to view this content.
Punnam
U are my hero, i am looking more at PIVOT now
Still Learning.
@sealpino
Since you got answers of several forummembers it is good to add to whom you replying.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks