Average Positive Values Only

[youngdaniel]

Hi All

I have a table of 70'000 lines of data, I need to average out a column that has figures ranging from -100 to 100.

however I only want to average out the positive values in the column.

so only values that are between 0-100.

can this be easily done using =AVERAGE????

 

[Krishnakumar]

Hi,

Try,

=AVERAGE(IF(A1:A10000>0,A1:A10000))

Array entered.

change the range to suit.

HTH

 

[youngdaniel]

great stuff

i have added FALSE in

=AVERAGE(IF(A1:A10000>0,A1:A10000,FALSE))

and works a treat!!

thank you!!