ble?
>
> Jim
>
> -Original Message-
> From: Michael Zalewski [mailto:zalew...@optonline.net]
> Sent: Tuesday, August 31, 2010 3:13 PM
> To: user@poi.apache.org
> Subject: Re: Help with SUM function
>
> Sounds like you are having a column with Subtotals and Grand To
PM
To: user@poi.apache.org
Subject: Re: Help with SUM function
Sounds like you are having a column with Subtotals and Grand Totals. The SUM
function that yields your grand total does not need to pick out ranges. Just run
the SUM function over the entire column
For example
A B
1 Sup
--Original Message-
From: Michael Zalewski [mailto:zalew...@optonline.net]
Sent: Tuesday, August 31, 2010 3:13 PM
To: user@poi.apache.org
Subject: Re: Help with SUM function
Sounds like you are having a column with Subtotals and Grand Totals. The SUM
function that yields your grand total does n
Sounds like you are having a column with Subtotals and Grand Totals. The SUM
function that yields your grand total does not need to pick out ranges. Just run
the SUM function over the entire column
For example
A B
1 Supplier #1 1.00
2 2.00
3 Subtotal @SUM(B1