Results 1 to 2 of 2

Thread: Sum every other row ?

  1. Oct 16th, 2006, 10:08 AM #1
    TheBionicOrange
    TheBionicOrange is offline

    Thread Starter
    Frenzied Member TheBionicOrange's Avatar
    Join Date
    Apr 2001
    Location
    Cardiff, UK
    Posts
    1,818

    Question Sum every other row ?

    Is it possible to sum every other row ?
    Or maybe sum rows where the row number is odd (or even) ?
    I'm looking at the SUMIF function, but I don't think that can handle what I am trying to do.


    Anyone ?
    Reply With Quote Reply With Quote
  2. Oct 16th, 2006, 10:18 AM #2
    TheBionicOrange
    TheBionicOrange is offline

    Thread Starter
    Frenzied Member TheBionicOrange's Avatar
    Join Date
    Apr 2001
    Location
    Cardiff, UK
    Posts
    1,818

    Re: Sum every other row ?

    never mind ... got it

    I used :

    =SUMPRODUCT((MOD(ROW(A1:A1000)-ROW(A1),2)=0)*(A1:A1000))

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width