Sum all identical merged columns, when Category has repetitions and must be repeated, and the same addition
It is best to have a one-step formula
Can someone please help me ? It would be much appreciated. Thanks in advance
Sum all identical merged columns, when Category has repetitions and must be repeated, and the same addition
It is best to have a one-step formula
Can someone please help me ? It would be much appreciated. Thanks in advance
Last edited by choletseng; 12-25-2022 at 01:02 AM.
One-step formula, please try:Formula:
Please Login or Register to view this content.
rows rather than columns
Power Query
Category Sum pencil 480ink 220ruler 80rubber stamp 60
![]()
Please Login or Register to view this content.
Last edited by sandy666; 12-25-2022 at 12:52 AM.
That's awesome, thank you both HansDouwe and sandy666
You are welcome
Have a nice day![]()
Glad to have helped. Thanks for the feedback and rep.
Happy holidays.
Cell E3 formula
Formula:
Please Login or Register to view this content.
@choletseng You're Welcome. Glad to help . Thank You for the feedback and rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks