Remember Me?

#1
February 14th 05, 10:09 PM
 Susannah Posts: n/a
How do I average positive numbers only

How do I average positive numbers only while ingnoring any zero or negative
values?

#2
February 14th 05, 10:13 PM
 Peo Sjoblom Posts: n/a

=AVERAGE(IF(Range0,Range))

entered with ctrl + shift & enter

--

Regards,

Peo Sjoblom

"Susannah" wrote in message
...
How do I average positive numbers only while ingnoring any zero or

negative
values?

#3
February 15th 05, 02:35 AM
 Susannah Posts: n/a

Thank you! One further question...I see how this works with sequential cells;
but if I want to average positive valued data from E7,E12,E22,E27 I can't
seem to get it to work.

"Peo Sjoblom" wrote:

=AVERAGE(IF(Range0,Range))

entered with ctrl + shift & enter

--

Regards,

Peo Sjoblom

"Susannah" wrote in message
...
How do I average positive numbers only while ingnoring any zero or

negative
values?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Susannah Excel Discussion (Misc queries) 3 February 11th 05 02:47 AM Kara Excel Discussion (Misc queries) 0 February 7th 05 02:11 AM Teri Excel Worksheet Functions 1 January 20th 05 09:33 PM Jerri Excel Discussion (Misc queries) 4 January 8th 05 06:05 PM Jacob Excel Discussion (Misc queries) 2 November 30th 04 01:24 AM

All times are GMT +1. The time now is 12:44 AM.