Count no of occurences of a cell in multiple columns and combine them together

Hi,
I have following task to do on a huge scale on multiple rows and several columns. Please see the screenshot.

2dh68tu.jpg
Given in the pic, AAA has two entries in MO1 both equal to 1. Their sum is 2.
It also has a single value in MO2. I want to combine sum of the values and put it into a single row for each column.

I hope this is clear otherwise please don't hesitate to reply.

Thanks

Looks like a Pivot Table would be the best solution.


Regards, TMS

please do not post images

@Martin: ah, you disappoint me ... I thought that was going to be a picture of a potential solution

Hi

You can use SUMPRODUCT for this.

=SUMPRODUCT(($A$2:$A$6=H2)*($B$2:$B$6))

Hope to helps you.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You are welcome