Thread: Big Sum
View Single Post
  #1   Report Post  
JavyD
 
Posts: n/a
Default Big Sum

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?