#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 27
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,389
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumif?? Hope Excel Worksheet Functions 9 January 12th 09 10:07 PM
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" Harry Seymour Excel Worksheet Functions 9 June 12th 07 10:47 PM
Embedding a Sumif in a sumif C.Pflugrath Excel Worksheet Functions 5 August 31st 05 07:31 PM
nested sumif or sumif with two criteria dshigley Excel Worksheet Functions 5 April 5th 05 03:34 AM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function Oscar Excel Worksheet Functions 2 January 11th 05 11:01 PM


All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"