Results 1 to 11 of 11

getting the average..

Threaded View

  1. #1
    Registered User
    Join Date
    03-10-2006
    Posts
    48

    getting the average..

    what formulas would i use to get and accurate average from a column? we will say row c20:c31. I would like to skip any value that is not greater then zero.

    example, row displays: 25,125,0,0,0

    I would like that range to show an average of 75... What i am getting is 30..

    ps- the zero's will change later to actual values so i would like to formulas to count them if they change from 0 to a number.
    Last edited by fivermsg; 03-10-2006 at 10:12 AM. Reason: doesn't look right

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