A
Anne
Hello,
I'm trying to average multiple ranges of data that have #n/a values. I know
how to use the array function with the if(isnumber) command for a single
range, but can this formula be extended to multiple ranges? Everytime I try
to build the formula I'm getting "error in your formula" message.
Thanks!
I'm trying to average multiple ranges of data that have #n/a values. I know
how to use the array function with the if(isnumber) command for a single
range, but can this formula be extended to multiple ranges? Everytime I try
to build the formula I'm getting "error in your formula" message.
Thanks!