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
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
Confirm this formula with Ctrl + Shift + Enter instead of just Enter.=AVERAGE(IF(ISNA(A1:A6),"",A1:A6))
Max
Did this work for you? Do you still need assistance with this one or can we mark it solved?
Yes it works. I do not remember getting any information on the problem before today.
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.
Posting Permissions
Reply With Quote
