How to add total from alternate cells?

[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

 

[Bob Umlas, Excel MVP]

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.

 

[azu_daioh]

Yep, that's what I'm looking for.
Thank you so much.