#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,069
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autosum Alan[_3_] Excel Discussion (Misc queries) 2 March 19th 07 12:35 PM
how do i set up autosum as a % Robert s Excel Worksheet Functions 1 February 7th 07 08:18 PM
autosum Kevin Excel Worksheet Functions 6 November 25th 06 06:51 PM
Autosum Stuart Perry Excel Discussion (Misc queries) 5 July 19th 05 08:45 PM
Autosum box too big [email protected] Excel Worksheet Functions 1 February 9th 05 01:31 AM


All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"