blakestandal
New Member
- Joined
- Sep 20, 2016
- Messages
- 8
Hello and thank you whomever is taking time to read this post. I really appreciate it. 
I have been tasked with helping my boss get a comprehensive excel doc together that saves a lot of time.
In doing this, I have made enormous progress, but i've hit a snag.
In a perfect world, I want to have a "cost breakdown" sheet that auto-populates the $ values according to what "category" each cost is under. All on a separate sheet.
attached are links to pictures with my predicament.
https://drive.google.com/a/energyst...0B58yjs0XislhbFE0TDJVVFgwbHc/view?usp=sharing
This shows my data table (without being filled in a whole lot). on the left you see a category, it's been set from a list of about 6 total categories, but could end up being more...
On the right, you see the subtotal price that is generated from these mock products.
I want to have multiples of the same category- more specifically, their $ value, be SUM-ed and placed on the next link's page.
https://drive.google.com/a/energyst...0B58yjs0XislhS29OTENqVmtlSkE/view?usp=sharing
you'll notice that I can get ONE value to populate in the cell. (solar, for instance works because its only looking for ONE value on the cost breakdown sheet, but I need it to auto-sum ALL corresponding values).
Please post to this thread if you have questions about my process or need more information to get a result!
I have been tasked with helping my boss get a comprehensive excel doc together that saves a lot of time.
In doing this, I have made enormous progress, but i've hit a snag.
In a perfect world, I want to have a "cost breakdown" sheet that auto-populates the $ values according to what "category" each cost is under. All on a separate sheet.
attached are links to pictures with my predicament.
https://drive.google.com/a/energyst...0B58yjs0XislhbFE0TDJVVFgwbHc/view?usp=sharing
This shows my data table (without being filled in a whole lot). on the left you see a category, it's been set from a list of about 6 total categories, but could end up being more...
On the right, you see the subtotal price that is generated from these mock products.
I want to have multiples of the same category- more specifically, their $ value, be SUM-ed and placed on the next link's page.
https://drive.google.com/a/energyst...0B58yjs0XislhS29OTENqVmtlSkE/view?usp=sharing
you'll notice that I can get ONE value to populate in the cell. (solar, for instance works because its only looking for ONE value on the cost breakdown sheet, but I need it to auto-sum ALL corresponding values).
Please post to this thread if you have questions about my process or need more information to get a result!
