Try using a sum function for the 3 cells rather than adding. Depending on the version of excel you are using, the sum function ignores text and only adds the numbers.
Kevin -----Original Message----- >From: [EMAIL PROTECTED] >Sent: Jun 5, 2008 8:03 PM >To: [email protected] >Subject: [CGUYS] Excel ? > >A very simple but perplexing problem. >A cell adds the values of 3 adjacent cells. >When text is keyed into one of the three cells, the cell adding the values >shows an error - #value. >Solution? >Thanks, >John. > > > >**************Get trade secrets for amazing burgers. Watch "Cooking with >Tyler Florence" on AOL Food. >(http://food.aol.com/tyler-florence?video=4?&NCID=aolfod00030000000002) > > >************************************************************************* >** List info, subscription management, list rules, archives, privacy ** >** policy, calmness, a member map, and more at http://www.cguys.org/ ** >************************************************************************* ************************************************************************* ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *************************************************************************
