I have a spreadsheet that updates links from other sheets daily. At the bottom it tallies the monthly runing totals.Since some of the source sheets do not have data yet entered, I get a #REF! in my cells that have no data, therefore my monthly accumalated also has #REF!.
How can I get it to ignore the #REF! and/or show these as blank?
Thanks-Greg
Of course you could edit each of your formulas with an IF statement to check for error codes and, if exist, return "" (this would be a lot of work, I'm thinking).
=IF(ISERROR(yourlinkhere),"",yourlinkhere)
However, this works for me and is only one cell to change:
=SUMIF(yourrange,">=0")+SUMIF(yourrange,"<0")
enter cell references to tally in place of 'yourrange'
This should ignore all cells with errors, text and the like.
Good Luck
Last edited by swatsp0p; 10-28-2005 at 12:32 PM.
Bruce
The older I get, the better I used to be.
USA
Where #REF! is returned, you might change your formula to
=IF(ISNUMBER(your formula here),your formula here,"")
This will prevent REF! from returning, and the sum will evaluate
properly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks