PDA

View Full Version : [SOLVED] Hiding a row



Tenspeed39355
01-14-2005, 06:10 AM
Good morning guys
I am tracking some stock funds and sometimes one of the funds goes into
default. When the fund goes into default I hide the row that the fund is in.
When I do an average on the column that the hidden row is in the answer comes up N/A. Is there a way to work around that problem?
Thanks for your help
Max

Jacob Hilderbrand
01-14-2005, 07:35 AM
What value is in the cell that has gone into default? If there is a #N/A error in the cell we can workaround this in a number of ways.

One way is to use an Array Formula

=AVERAGE(IF(ISNA(A1:A6),"",A1:A6))
Confirm this formula with Ctrl + Shift + Enter instead of just Enter.

Jacob Hilderbrand
01-21-2005, 01:39 AM
Max

Did this work for you? Do you still need assistance with this one or can we mark it solved?

Tenspeed39355
01-21-2005, 04:55 AM
Yes it works. I do not remember getting any information on the problem before today.

Jacob Hilderbrand
01-21-2005, 04:59 AM
Ok, glad it worked for you. Now go ahead and mark it Solved. From the top post, click where it says Thread Tools. Then click Mark Solved, then Perform Action.

:beerchug: