LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Summing large number of non contiguous cells evenly distributed

Hello!

Is there a way to enter a summing formula so that it looks at every 42nd
cell in a range of cell e6 thru e1602 and sums each cell to a grand total?

I could do =sum(e6+e48+e90............all the way to e1602, but with the
size of this sheet that would take me hours.....or a whole day. I don't have
that much time, and there are over 120 different columns of data I'll have to
do this for......

Thanks!


--
Thank you all for your help!
 
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
Columns distributed evenly in worksheet Aussie[_2_] Excel Discussion (Misc queries) 3 July 2nd 08 09:10 PM
summing non-contiguous array cells WRC Excel Worksheet Functions 10 November 5th 07 10:26 PM
Spreading 1 large number evenly into several cells Dos Equis Excel Worksheet Functions 0 October 4th 06 05:50 PM
Summing non contiguous cells Millie Excel Discussion (Misc queries) 4 August 10th 06 10:23 PM
Summing non-contiguous cells Cheryl Excel Worksheet Functions 6 April 26th 05 03:04 AM


All times are GMT +1. The time now is 11:46 PM.

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"