Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add columns horizontally? A1+B1; A2+B2
I have found nothing that tells me how to a simple addition of the individual
items in one column with another column. That is, I want to add A1 & B1; A2 & B2, etc. Or any other math function. I have 169 data items in each column, and need to do multiple math functions on the items, which are all related horizontally. Excel Help is helpless as far as I can tell--offering no clear guidance for what seems to me a very simple programming step. Surely there is a way. FC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add columns horizontally? A1+B1; A2+B2
It isn't clear this is what you want, but for your consideration:
Sub Tester1() Dim rng as Range, cell as Range set rng = Range(Cells(1,1),Cells(1,1).End(xldown)) for each cell in rng cell.offset(0,2).Value = Cell.Value + cell.offset(0,1).value Next End Sub -- Regards, Tom Ogilvy "FredVC" wrote in message ... I have found nothing that tells me how to a simple addition of the individual items in one column with another column. That is, I want to add A1 & B1; A2 & B2, etc. Or any other math function. I have 169 data items in each column, and need to do multiple math functions on the items, which are all related horizontally. Excel Help is helpless as far as I can tell--offering no clear guidance for what seems to me a very simple programming step. Surely there is a way. FC |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add columns horizontally? A1+B1; A2+B2
The mathematical manipulations you desire to perform are instrumented in
Excel as "equations" or "formulae" You have data in columns A and B and wish to view the sums pair-wise. First you must select the column in which you wish the sums to appear. Let's pick column C. In cell C1 enter the following: =A1+B1 Then select cell C1, copy it and then paste into cells C2 thru C169. -- Gary's Student gsnu200703 "FredVC" wrote: I have found nothing that tells me how to a simple addition of the individual items in one column with another column. That is, I want to add A1 & B1; A2 & B2, etc. Or any other math function. I have 169 data items in each column, and need to do multiple math functions on the items, which are all related horizontally. Excel Help is helpless as far as I can tell--offering no clear guidance for what seems to me a very simple programming step. Surely there is a way. FC |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add columns horizontally? A1+B1; A2+B2
More information can be found in VBA help under the specific operators of +,
-, *, / and the comparison operator =. "FredVC" wrote: I have found nothing that tells me how to a simple addition of the individual items in one column with another column. That is, I want to add A1 & B1; A2 & B2, etc. Or any other math function. I have 169 data items in each column, and need to do multiple math functions on the items, which are all related horizontally. Excel Help is helpless as far as I can tell--offering no clear guidance for what seems to me a very simple programming step. Surely there is a way. FC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can an Autofilter go horizontally? | Excel Discussion (Misc queries) | |||
How can i fill horizontally? | Excel Worksheet Functions | |||
Different columns according to value horizontally | Excel Discussion (Misc queries) | |||
How to turn rows horizontally to form columns? | Excel Worksheet Functions | |||
Autofilter horizontally? | Excel Discussion (Misc queries) |