Sum of all numbers of column against unique number of other column

Hi Freinds,

Sum of all numbers of column against unique Value (alfa numeric) of other column , and which are (unique numbers) against the repeated value (Alfa) of other column.

This is three stage relationship order, which is not easy to develop, but I believe in this forum we have great minds, which will surely solve this problem.

My first problem was to solve the sum of all data in a column against the repeated word of other column, which had been solved by the use of sumproduct formula.

But, this problem is to first get all the data against a repeated cell of one column in second column and find the sum of all numbers in 3rd column against unique value (alfa numberic) of 2nd column as filterd against some repeated value of 1st column.
Attached sheet is having further explanation,,,,,,,,,,,,,,,,,,,,,
Thanks in advance

Use a Pivot Table.

I find the description very confusing but have come up with my best guess of what you are after.
I added a column to the table of values that you have and called it Rupee Note Sum with the following formula under the title and filled down: This returns a value for each unique name from column H and 1 value for any repeated names.

Formula:

Please Login or Register  to view this content.

In C3, I entered this formula and filled down. This gives the sum for all the values obtained in the above formula for each name in column F.

Formula:

Please Login or Register  to view this content.

Someone conversant in VBA could do this easily I'm thinking. That isn't me