Results 1 to 3 of 3

calculating averages

Threaded View

  1. #1
    Registered User
    Join Date
    12-04-2003
    Posts
    42

    calculating averages

    I have a range of data sat c1:c16 and a set of values as below

    26.1
    33.3
    16.0
    8.5
    0.0
    41.4
    34.7
    27.4
    52.2
    23.1
    13.5
    35.1
    13.9
    62.9
    82.6
    16.4

    i want to calculate the average of the range greater than 0. how do i do this?
    Last edited by NBVC; 08-24-2011 at 03:45 PM.

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