Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Showing totals from two columns
Is there a way to show the totals from two columns?
For example, say I have the number 15 in column A and 7 in column B, I need column C to look like this: 15, 7 But instead I can only get them to appear together giving me 157??? Are there any suggestions? Thanks! |
#2
|
|||
|
|||
Try A1 & ", " & B1
Art "Kristin" wrote: Is there a way to show the totals from two columns? For example, say I have the number 15 in column A and 7 in column B, I need column C to look like this: 15, 7 But instead I can only get them to appear together giving me 157??? Are there any suggestions? Thanks! |
#3
|
|||
|
|||
=SUM(A1:A5)&","&SUM(B1:B5)
-- Kind Regards, Niek Otten Microsoft MVP - Excel "Kristin" wrote in message ... Is there a way to show the totals from two columns? For example, say I have the number 15 in column A and 7 in column B, I need column C to look like this: 15, 7 But instead I can only get them to appear together giving me 157??? Are there any suggestions? Thanks! |
#4
|
|||
|
|||
Perfect! Thank You!
"Art" wrote: Try A1 & ", " & B1 Art "Kristin" wrote: Is there a way to show the totals from two columns? For example, say I have the number 15 in column A and 7 in column B, I need column C to look like this: 15, 7 But instead I can only get them to appear together giving me 157??? Are there any suggestions? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |