+ Reply to Thread
Results 1 to 3 of 3

Problem with sum function

  1. #1
    Registered User
    Join Date
    01-07-2005
    Posts
    21

    Problem with sum function

    =SUM(E7,E11,E15,E19,E23,E27,E31,E35,E39,E43,E47,E51,E55,E59,E67,E71,E75,E79,E83,E87,E91,E95,E99,e103,e107,e111,e115,e119,e123,e127,e131,e135,e139,e143,e147,e151,e155,e159,e163,e167,e171,e175,e179,e183,e187,e191,e195,e199,e203,e207,e211,e215,e219,e223,e227,E231)

    Anyway I can make this work without breaking it down into different equations? I am receiving an error because I am exceeding the 30 parameters

    Thanks.

  2. #2
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474
    Try...

    =SUMPRODUCT(--(MOD(ROW(E7:E231)-CELL("row",E7)+0,4)=0),E7:E231)

    Hope this helps!

  3. #3
    Registered User
    Join Date
    01-07-2005
    Posts
    21
    You are a genious Domenic...

    Pure Genious

    Thanks again

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1