+ Reply to Thread
Results 1 to 2 of 2

Summation Formula Question (Code Inside)

Hybrid View

  1. #1
    cjwenngatz@gmail.com
    Guest

    Summation Formula Question (Code Inside)

    I am trying to sort through a file and select only the 25th line of a
    secondary worksheet titled "raw data". The basic formula I was using is
    below:

    =SUM((E4:E23)*(MOD(ROW(E4:E23)-ROW(E4);5)=0))

    My formula looks like this:

    =SUM(('Raw Data'!B36:B16500)*(MOD(ROW('Raw Data'!B36:B16500)-ROW('Raw
    Data'!B36);25)=0))

    It won't work, and I'm wondering what I'm doing wrong.

    Thanks.


  2. #2
    cjwenngatz@gmail.com
    Guest

    Re: Summation Formula Question (Code Inside)

    Anyone?


+ 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