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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
No data found
For these types things, it's usual to 'wrap' them in a test for an error
condition with an IF statement, like this: =IF(ISNA(Sunday!AQ5),0,Sunday!AQ5) Do an Excel search in HELP for the ISNA function and check out the "See Also" which will lead you to things like ISERR and ISERROR. What you have to be careful about with these error trapping functions is that you don't hide something else with them. Best to at least work out the basic formulas with associated data to make sure that nothing unexpected shows up. In this case you expect an #NA! so the test is a good one to put here. IF(ISNA(),"error","no error") type setup is also very useful with the various xLOOKUP() functions. Hope this is helpful for you. "Barry" wrote: 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. |
Reply |
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 |