ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Averaging multiple ranges with #n/a values (https://www.excelbanter.com/excel-discussion-misc-queries/198725-averaging-multiple-ranges-n-values.html)

Anne

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