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?![]()
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks