populate listbox with sum of unique value form another column

[cherrydee]

Hi, I would like to populate my listbox1 with values from a worksheet called "Summary"
The listbox result should be:
1st column: Unique Payee names
2nd column: sum of their gross
3rd column: sum of their tax
4th column: sum of their net

Payee	Gross	Tax	Net
Person1	10,000	3,000	7,000
Person2	1,500	500	1,000
Person1	2,000	300	1,700
Person2	5,000	1,000	4,000

Tried:

Please Login or Register  to view this content.

Since I only got these codes from somewhere else, I tried messing around with the values inside the q() but I can't seem to get the right column offset.

[AlphaFrog]

Attach a sample workbook (not a picture or pasted copy). 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 Attachments to open the upload window.

[cherrydee]

Attached is my test file including a sample data and a semi-working userform. Thank you

[AlphaFrog]

Please Login or Register  to view this content.

[cherrydee]

Yay, thank you very much Mr. Frog!
Will try to digest your codes for future reference. Have a nice day!