Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiplication macro
multiplication macro
hi there in sheet 1 , in column c starting from c1 , i have lots of data going downwards... in sheet 2 i have a matrix starting from cella1 , number of rows in sheet 1 and 2 are same.... i want to be able to multiply cellc1 ( from sheet1 ) with sum of columnA ( in sheet 2 , and then c2 with sum of column b , and then c3 with sum of column C and so on ... i want to see all this sheet 3 , cell f5 onwards.... how do i do this using a mcro ? can some one plsssss help ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiplication macro
Sam,
In cell F5 of sheet3, use the formula =Sheet1!C1*SUM(INDIRECT("Sheet2!"&ADDRESS(1,ROW()-4)&":"&ADDRESS(65536,ROW()-4))) and copy down for as many rows as your need. If you want to copy accross, that's a different formula. HTH, Bernie Excel MVP "Sam" wrote in message om... multiplication macro hi there in sheet 1 , in column c starting from c1 , i have lots of data going downwards... in sheet 2 i have a matrix starting from cella1 , number of rows in sheet 1 and 2 are same.... i want to be able to multiply cellc1 ( from sheet1 ) with sum of columnA ( in sheet 2 , and then c2 with sum of column b , and then c3 with sum of column C and so on ... i want to see all this sheet 3 , cell f5 onwards.... how do i do this using a mcro ? can some one plsssss help ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiplication macro
Sam,
Here's the formula for Sheet3 cell F5 if you want to copy across. =INDIRECT("Sheet1!C" & COLUMN()-5)*SUM(Sheet2!A:A) HTH, Bernie Excel MVP "Sam" wrote in message om... multiplication macro hi there in sheet 1 , in column c starting from c1 , i have lots of data going downwards... in sheet 2 i have a matrix starting from cella1 , number of rows in sheet 1 and 2 are same.... i want to be able to multiply cellc1 ( from sheet1 ) with sum of columnA ( in sheet 2 , and then c2 with sum of column b , and then c3 with sum of column C and so on ... i want to see all this sheet 3 , cell f5 onwards.... how do i do this using a mcro ? can some one plsssss help ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Like SUMIFS, but for multiplication??? | Excel Worksheet Functions | |||
Multiplication | Excel Worksheet Functions | |||
multiplication | Excel Worksheet Functions | |||
Charts multiplication | Charts and Charting in Excel | |||
matrix multiplication | Excel Programming |