| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
No data found
Hi, I have a work sheet that has several sheets the fist is the master and it
records scores from each of the other sheets so the first cell would read some thing like (=Sunday! AQ5) the trouble is if there is no data to record the cell reads #N/A so I can not Add up all the cells un less I replace all the #N/A with zeros, is there any way around this. Can any one help? Thanks in advance. Barry. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display zero is no data is found | Excel Discussion (Misc queries) | |||
| Duplicate Row for data found in columns | Excel Discussion (Misc queries) | |||
| Stop a loop when certain data is found | Excel Discussion (Misc queries) | |||
| Vlookup data wrong if the small value found are same | Excel Discussion (Misc queries) | |||
| Data Source Name Not Found | Excel Worksheet Functions | |||
Threaded Mode
