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