![]() |
Averaging multiple ranges with #n/a values
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! |
All times are GMT +1. The time now is 07:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com