Thread: No data found
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
barry barry is offline
external usenet poster
 
Posts: 116
Default 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.