From: Robb27 on 14 Mar 2010 19:01 I need to sum two cells together as long as either of the two cells have numbers in them. If either of the two cells has "A" in it, then I need to concantenate the two cells. Like this: E is the column where the formula is. A and B are the columns where the cells are to either add or concantenate. A B C D E 2 8 10 (Cells are added 2 + 8) A 8 A8 (Cells concantenated A8) Is it IF A2=A THEN CONCANTENATE A2&B2, IF A2=2-10, THEN SUMIF? Thanks, Rob From: Fred Smith on 14 Mar 2010 19:05 In E2: =if(a2="A",a2&b2,a2+b2) Copy down Regards, Fred "Robb27" wrote in message news:4554F195-8697-4CD4-96DF-3DEF2D862CE6(a)microsoft.com...>I need to sum two cells together as long as either of the two cells have > numbers in them. If either of the two cells has "A" in it, then I need to > concantenate the two cells. Like this: > E is the column where the formula is. A and B are the columns where the > cells are to either add or concantenate. > A B C D E > 2 8 10 (Cells are added 2 + 8) > A 8 A8 (Cells concantenated A8) > > Is it IF A2=A THEN CONCANTENATE A2&B2, IF A2=2-10, THEN SUMIF? > > Thanks, > Rob  |  Pages: 1 Prev: slow worksheetNext: Compound Interest Rate or Growth Rate