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: 41
Default How to dealing with functions with 30+ variables?

I have a worksheet that has over 2000 rows and every 4th row I have a number
that I am trying to sum up. Currently I understand that I can not have more
then 30 variables in a function so I take 30 rows at a time then sum up the
results and adding them up. Here is what I am using now as a formula:
=SUM(C4,C8,C12,C16,C20,C24,C47,C51,C55,C59,C63,C67 ,C28,C32,C37,C71,C75,C79,C83,C87,C93,C97,C101,C105 ,C109,C113,C117,C121,C125,C129)
I take that result and added to the rest for ever 30 rows

The worksheet is getting bigger by the day and I need something that adds
every 4th row no matter how many rows I have. All the help will be greatly
appreciated. Thank you.

 
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
Confused about setting up functions based on variables? NotExcelingNow Excel Worksheet Functions 5 January 9th 08 07:31 PM
Functions/Formulas to count multiple variables 2many#s Excel Worksheet Functions 7 June 20th 07 05:20 AM
constructing (complex) variables with worksheet functions broer konijn Excel Discussion (Misc queries) 0 May 16th 06 10:55 PM
LOGICAL FUNCTIONS WITH MULTIPLE VARIABLES luiss Excel Worksheet Functions 3 November 18th 05 04:08 PM
Can I use variables for workheet name references in Excel functions? Amihai Bareket Excel Discussion (Misc queries) 1 February 4th 05 05:11 PM


All times are GMT +1. The time now is 10:59 PM.

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

About Us

"It's about Microsoft Excel"