Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum a variable database
I need to sum a spreadsheet that looks like a schedule
(waterfall) chart. Each row has data about quanities of a specific item. The data starts in a column goes for a few columns then stops. Each column is a month of the year (s). A column on the left has the type of item that is in that particular row. The rows can be any type of item but each row only contains one item. I have about 6 items to sum that may change. I want to sum the items by row and sum the items by month. I have rows at the bottom that contain a sum for each item for each month. I would like suggestions on the equations to use at the bottom. I could use flat database with a pivot table but the input looks like a waterfall chart. Suggestions? Ken |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Variable passed to database query | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
How set up a template/form & database that records variable rows . | Excel Discussion (Misc queries) |