| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why did I use array formula - help
Hi,
I used the following in a spreadsheet over a year ago and can't remember how, why, or what I've done. Head spinning because I'm making unexpected changes which were needed "Now, if not sooner" The formula below is entered as an array formula but don't know why {=IF(ISERROR(AVERAGE(IF(Score0,Score))),"",AVERAG E(IF(Score0,Score)))} Named range "Score" is a dynamic range as below =OFFSET('Sheet1'!$Q$1,0,0,COUNTA('Sheet1'!$Q$1:$Q$ 35),1). If anyone can help I would be grateful :-) Cheers Diddy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula SUMIF with 2D sum_range array | Excel Worksheet Functions | |||
| Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
| Find specific value in array of array formula | Excel Worksheet Functions | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions | |||
Threaded Mode
