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=210, 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" <Robb27(a)discussions.microsoft.com> wrote in message news:4554F19586974CD496DF3DEF2D862CE6(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=210, THEN SUMIF? > > Thanks, > Rob

Pages: 1 Prev: slow worksheet Next: Compound Interest Rate or Growth Rate 