| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ignore #N/A in a sum?
I have a worksheett that has many #N/A's where a matching formula brought
over data. It there is no match I get another N/A's. Thats ok, but I need to sum accross the rows and I don't want to remove the formula. I am adding three columns +F160+G160-H160 Is there a formula I can use? Or do I really need to delete all the N/A's. ( I will just have to put them back later if I do). Thanks, Todd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignore Text when calculating time | Excel Discussion (Misc queries) | |||
| Problems with Ignore Other Applications | Excel Discussion (Misc queries) | |||
| Ignore N/A values with an area chart | Charts and Charting in Excel | |||
| Ignore Blanks in Data Validation | Excel Worksheet Functions | |||
| How do I ignore newline character/carriage return while importing | Excel Discussion (Misc queries) | |||
Threaded Mode
