| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum with Array Formula
I am trying to get an array formula to sum up a set of terms.
=OFFSET(cll,0,1)+OFFSET(cll,0,2)+OFFSET(cll,0,3) where cll is a Named Range =SUM(OFFSET(cll,0,{1,2,3})) does not work -- Gary''s Student - gsnu200787 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula | Excel Discussion (Misc queries) | |||
| 3 Array Formula | Excel Discussion (Misc queries) | |||
| Array Formula | Excel Discussion (Misc queries) | |||
| 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
