| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
I think you want
=SUM(IF(NOT(ISERROR(A1:A100)),A1:A100) which is an error, so commit with Ctrl-Shift-Enter. -- HTH RP (remove nothere from the email address if mailing direct) "HeatherC" wrote in message ... How do I sum a range of cells that include a #N/A error. I want the #N/A cells to register as 0. Currently the total returned is also #N/A. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| Formula help for using a range of cells! | Excel Worksheet Functions | |||
| How can I dynamically eliminate blank cells in a given range in E. | Excel Worksheet Functions | |||
| How do you delete one cell from a range of protected cells | Excel Worksheet Functions | |||
| Excel-value in a range of cells for two cross references | Excel Worksheet Functions | |||
Hybrid Mode
