| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
running sum needed with #N/A in array
This will ignore *all* errors:
=SUMIF(B2:B15,"<1E100") -- Biff Microsoft Excel MVP "Lois" wrote in message ... I am trying to get a running sum from a list of VLookups where some of the values have yet to be entered. Therefor some of the cells show as #N/A and the sum formula SUM(B2:B15) is not working. How can I fix this. (just in case not clear b2 is 5:47, B3 is 5:52 B4:b15 are currently #N/A but will change on later dates) -- Thanks so much Lois - unskilled user |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RUNNING TOTALS...FORMULA NEEDED | Excel Worksheet Functions | |||
| Maybe an array is needed? | Excel Worksheet Functions | |||
| Running total array? | Excel Worksheet Functions | |||
| Formula Needed to Compare Dates and return a running total | Excel Worksheet Functions | |||
| Urgent Help needed - I need to stop a process that is running forever in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
