Grand Totals without subtotals

M

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
 
J

JMay

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


melvin said:
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
Click to expand...
creating financial statements
 
Top