| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT to substiute array formula
I have this formula
=SUM(IF(ISERROR(A1:A100),0,A1:A100)) entered as an array formula, to sum a column even if some of the cells contains error values. Now I wonder if it could be done using SUMPRODUCT or any other functions, to avoid the array formula? Jan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct and Array Formula | Excel Discussion (Misc queries) | |||
| Help with Possible Array or Sumproduct Formula | Excel Worksheet Functions | |||
| substiute formula = subing something to " | Excel Worksheet Functions | |||
| Array formula for SUMPRODUCT | Excel Worksheet Functions | |||
| SUMPRODUCT as array formula? | Excel Worksheet Functions | |||
Threaded Mode
