sumif concatenate formula
On Wed, 17 Mar 2010 14:45:03 -0700, Robb27
wrote:
I have 3 cells in a row. We'll call them cell 1, 2 & 3. I need a formula in
cell 3 that is based on what is in cells 1 and 2. Example:
1 - If there is a letter "A" in cell 1 or 2, then concatenate cells 1 and 2
in cell 3.
2 - If there is number in cell 1 and 2, then sum cells 1 and 2 in cell 3.
Thanks for your help.
Rob
If cell 1 is cell A1 and cell 2 is cell A2, try this formula in cell
3:
=IF(OR(A1="A",A2="A"),A1&A2,IF(AND(ISNUMBER(A1),IS NUMBER(A2)),A1+A2,""))
Hope this helps / Lars-Åke
|