Ignoring a row of data

T

Turnipboy

I have column of data in the form:

x y
1 6
4 3
6 0

I have plotted x vs y and also calculated the average of y. How can
easily ignore a row of data, without deleting it, so that it does no
appear in the graphs AND is no longer taken into account when findin
the average of the y column - i.e. AVERAGE(B2:B4). HIDE does not see
to satisfy the last condition
 
B

Bob Phillips

=AVERAGE(IF(B2:B200)>0,B2:B200)

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
T

Turnipboy

Thanks but I can't get this to work. Just to clarify I want to be abl
to ignore various rows but still have the other rows take part in a
averaging of columns and also appear in graph
 
Top