VBA SumIF

[kamaflage]

Hi Experts,

I apologize if i am not explain my request clearly.


On the below example I would like sum all the same customers total and also the Due amount.
then i would like to divide the Due by the Total.

The result I would like in a msg box..or on a new worksheet
example

TestA is X%
TestB is X%
TestC is X%


The problem is I will never know how many different customers there will be or how many different account, so some flexibility is needed to accommodate this.


Is this request possible?


example.JPG

[mehmetcik]

Please Login or Register  to view this content.

[kamaflage]

Please Login or Register  to view this content.

Hi,
Thank you for replying.
I can see how the above will work however is it possible to use a array to capture the unique customers and add it to the above formula?
If possible I would like it done using vba.

[mehmetcik]

Do you want an Array Formula or a Macro?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachements to open the upload window.

View Pic