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.

"(E-Mail Removed)" wrote:

> 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
>

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