sumif
 

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

sumif
 

In E2:
=if(a2="A",a2&b2,a2+b2)
Copy down

Regards,
Fred

"Robb27" wrote in message
...
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