ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   autosum (https://www.excelbanter.com/excel-discussion-misc-queries/180462-autosum.html)

John

autosum
 
I have a very large file and want to exclude cells in a contiguous autosum.
There are too many (more than 30) agruements for SUM. Is there a way to
exclude cells in a contiguous autosum?
--
John

Jim Thomlinson

autosum
 
Is there some kind of criteria that you are using to define the values you do
not want to sum? Are you wanting to exclude subtotals? What makes the 30+
numbers you want to exclude special?
--
HTH...

Jim Thomlinson


"John" wrote:

I have a very large file and want to exclude cells in a contiguous autosum.
There are too many (more than 30) agruements for SUM. Is there a way to
exclude cells in a contiguous autosum?
--
John



All times are GMT +1. The time now is 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com