Grand Totals without subtotals

[melvin]

Hi,

I am preparing a number of tables, all of different sizes. I woul
like to record a command in a macro that will calculate the Grand Tota
of a specific column even though the number of rows in that column wil
vary for each table I prepare. The 'subtotals' command is perfect fo
this, except I do not require to subtotal any column at a specifi
change, only Grand Total the entire column. I have tried using
simple 'sum' forumla, however this doesn't seem to work in tables wit
a larger/smaller number of rows as it selects the exact cell I recorde
in the macro.

Does anyone know a way round this??

Cheers folks,

Mel

 

[JMay]

Put this in a Non-"D" Column Cell
=SUM(D)

Hi,

I am preparing a number of tables, all of different sizes. I would
like to record a command in a macro that will calculate the Grand Total
of a specific column even though the number of rows in that column will
vary for each table I prepare. The 'subtotals' command is perfect for
this, except I do not require to subtotal any column at a specific
change, only Grand Total the entire column. I have tried using a
simple 'sum' forumla, however this doesn't seem to work in tables with
a larger/smaller number of rows as it selects the exact cell I recorded
in the macro.

Does anyone know a way round this??

Cheers folks,

Melv


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements