Hello Everyone,

Right now I have a table, where over 100 items have a monthly fcst and a
cost. So far, I have two columsn with Total Units as a sum and a cost
column. Thus another column would tell me the total dollars. But I would
like to break it up for a total dollar for each month. But again, theres
over a hundred items. Table looks like so

Item Jan Feb Mar Apr etc Total Cost
Total $$
1700 120 136 145 30 2000 1.5 3000

Well, I need Monthly $$ on top of each month, is t his p ossible. Right now
I have hidden columns with formulas that calculate the Monthly Dollars and
just reference above the Original Months that shows the hidden sum. Is there
a more efficient way?

Javy,

There is a more efficient way: pivot tables. You can use the grouping
function to group your data by month - no fomulas involved, just a bit of a
learnig curve.

HTH,
Bernie
MS Excel MVP


"JavyD" wrote in message
...
Hello Everyone,

Right now I have a table, where over 100 items have a monthly fcst and a
cost. So far, I have two columsn with Total Units as a sum and a cost
column. Thus another column would tell me the total dollars. But I would
like to break it up for a total dollar for each month. But again, theres
over a hundred items. Table looks like so

Item Jan Feb Mar Apr etc Total Cost
Total $$
1700 120 136 145 30 2000 1.5
3000

Well, I need Monthly $$ on top of each month, is t his p ossible. Right
now
I have hidden columns with formulas that calculate the Monthly Dollars and
just reference above the Original Months that shows the hidden sum. Is
there
a more efficient way?