View Single Post
  #1  
Old March 17th, 2010, 09:45 PM posted to microsoft.public.excel.worksheet.functions
Robb27
external usenet poster
 
Posts: 14
Default 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