Forum Discussion
Joni_B
May 24, 2021Copper Contributor
Excel function needed
Excel novice here... I am in need of a function to give me the following outcome. If the value in column A is the same then add the values in column B. All help is appreciated! Thank you,...
Riny_van_Eekelen
May 24, 2021Platinum Contributor
Joni_B What you ask for is possible with a Pivot Table, I believe. Added a worksheet "Sheet1" with such a table. Is that what you hand in mind?
More about pivot tables in the attached link.
Joni_B
May 24, 2021Copper Contributor
Yes! This is what I need! I have never used pivot tables. Will the link you provided be able to walk me through this?
- Riny_van_EekelenMay 24, 2021Platinum Contributor
Joni_B The link has it all. And there are many other resources on-line with videos tutorials etc. Just search for "pivot table excel".