If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
sumif concatenate formula
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
sumif concatenate formula
=IF(COUNT(A1:B1)=2,A1+B1,IF(OR(A1="A",B1="A"),A1&B 1,""))
"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 |
#4
|
|||
|
|||
sumif concatenate formula
Try this...
=IF(COUNT(A1:B1)=2,A1+B1,IF(OR(A1="A",B1="A"),A1&B 1,"")) -- Biff Microsoft Excel MVP "Robb27" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|