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


--
singlgl1
------------------------------------------------------------------------
singlgl1's Profile: http://www.excelforum.com/member.php...o&userid=26389
View this thread: http://www.excelforum.com/showthread...hreadid=480138