How to add total from alternate cells?

  • Thread starter Thread starter azu_daioh
  • Start date Start date
A

azu_daioh

I have a rollup worksheet and using a macro it gathers all the VOL and
MIN columns from the other worksheets onto the rollup worksheet. But
I would like to add a GRAND TOTAL VOL and GRAND TOTAL MIN on the
rollup worksheet.

Before the macro is run, the rollup worksheet contains the following
columns where A and B corresponds to the column letter.

A: Grand Total Vol
B: Grand Total Min

After the macro is run, the rollup worksheet will have the following
column headings:

A: Grand Total Vol
B: Grand Total Min
C: 202 VOL
D: 202 MIN
E: 203 VOL
F: 203 MIN
G: 204 VOL
H: 204 MIN


I would like to be able to display the grand total on each row for VOL
and MIN. How do I formulate it without doing it manually (Grand
Total Vol =C1+E1+G1+I1+K1...)??

Thanks for the help,

Sharon
 
Assuming VOL/MIN are characters in row 2:
=SUMIF(C2:IV2,"VOL",C1:IV1) will add up the VOLs, and
=SUMIF(C2:IV2,"MIN",C1:IV1) will add up the MINs.
 
Back
Top