Average Positive Values Only

youngdaniel

New Member
Joined
Jul 26, 2004
Messages
38
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????
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Krishnakumar

Well-known Member
Joined
Feb 28, 2003
Messages
2,615
Hi,

Try,

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

Array entered.

change the range to suit.

HTH
 

youngdaniel

New Member
Joined
Jul 26, 2004
Messages
38
great stuff

i have added FALSE in

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

and works a treat!!

thank you!!
 

Watch MrExcel Video

Forum statistics

Threads
1,119,129
Messages
5,576,267
Members
412,710
Latest member
Maged elmasry
Top