Please help, intricate subtotal for main accounts with many sub accounts!!

Hello,

I have a large file that gives me all of the sales for every month from the entire year. My goal is to get the total for the overall accounts and come up with a report to show overall sales numbers.

My problem comes when I do a pivot table to get the data, it will give me all of the individual accounts, but not the overall accounts.
Example:
John Deere-Powertrain
John Deere-Engine
John Deere-Lawn works

I want to see all of these under the main account of John Deere.

I tried using a (left) function to give me similar fields then pivot table from there to get total sales numbers, but the problem is i have accounts like Americorp and Ameritech, so using the left function would combine separate accounts, and if I go out too far, i would revert to problem 1.

Is there an easy way to do this?


Thanks in advance.

Assuming your Data in A1 to A3 as
John Deere-Powertrain
John Deere-Engine
John Deere-Lawn works

then in C1 you can try =countif(A1:A3,"*John Deere*")
Hope this helps

if this solves your query mark thread as solved and Click" * " from bottom left corner of my post

Regards