SUBTOTAL amounts paid to each vendor by name.

I imported a QB file into Excel. Column on left contains vendor names sorted alphabetically. Column on right contains Amounts paid to each vendor. So each vendor will have multiple amounts paid. I'm looking for way to subtotal (sum) all amounts paid to each vendor, bold the total and then give me a blank row after each subtotal. I could do this manually but it will take me for ever. I am an entry level Excel user (Office 365) and am new to this site.

Bill

Hi and welcome,


you can automatically calculate subtotals and grand totals in a list for a column by using the Subtotal command: in Data menù click on Subtotal (it's on the right)


To insert a blank row, you could follow this instructions:


https://www.excelarticles.com/excelb..._subtotal.html

https://www.youtube.com/watch?v=kqGbHv0X5Yo

Hope it helps

Hi Bill and welcome to the forum.

Can I suggest you upload a workbook and manually add the results you expect to see.
You may find you get an answer without needing to take this further.

If not, are you aware of the Commercial Services forum we have? There you can offer an amount for a bespoke solution.

When I click Subtotal in the Data Tab I get an error message that says, " Excel cannot determine which row in your list or selection contains column labels, which are required for this command." But all of my columns have column names (labels) and the two relevant ones are Name and Amount. Suggestions?

Administrative Note:

Welcome to the forum.

Unfortunately your post does not comply with Rule #12 of our Forum RULES:

Do not solicit payments in your posts or signatures.

This is a free forum manned by volunteers, and as such, all help sought or offered here is for free. The ONLY exception is the Commercial Services section where members can pay for senior forum members to look at their problem and provide bespoke one-to-one solutions, but even here no freelancing is allowed.

Please remove your request for or offer of payment from your post and/or signature line.

(Note: this change is not optional. As you are new here, I have done it for you this time.)

You are getting help here for free, so maybe you don’t need to. If you do go down that route, you will need to click on the commercial services link and purchase points, however you won’t then be allowed to keep this thread open. In addition you need to know that members who are able to help in commercial services are currently struggling to get money owed to them from the site’s owners, so some are reluctant to help there at present, and if you buy points, the money may not reach the person who helps you. In brief, you are better off staying here in the free section.

Originally Posted by MAC851971

Hi Richard:

I have a ss that shows the exact results I am looking for. Can I upload that as an attachment. I'm not familiar with how to create a Workbook. I actually thought I was making this post in the Commercial Services section. I bought points.

Bill

To upload a file click the 'Go Advanced' button at the foot of the post then look underneath the post area for the 'Manage attachments' option and take it from there.