View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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