+ Reply to Thread
Results 1 to 2 of 2

Averaging non-range positive data

  1. #1
    Susannah
    Guest

    Averaging non-range positive data

    How do I take data from E7,E12,E17,E22,E27 and average only those cells
    containing positive data?

  2. #2
    Peo Sjoblom
    Guest

    Re: Averaging non-range positive data

    Is it always every 5th cell? If so you can use

    =SUMPRODUCT(--(MOD(ROW(E7:E300),5)=2),--(E7:E300>0),E7:E300)/SUMPRODUCT(--(MOD(ROW(E7:E300),5)=2),--(E7:E300>0))

    --


    Regards,

    Peo Sjoblom


    "Susannah" <[email protected]> wrote in message
    news:[email protected]...
    > How do I take data from E7,E12,E17,E22,E27 and average only those cells
    > containing positive data?




+ 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