| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Divide a range by a corresponding range
Similar to sumproduct, I would like to divide each data in entry column by
the standard weight per unit in corresponding column, to return a value representing total units produced. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Divide a range by a corresponding range
still use SUMPRODUCT():
=SUMPRODUCT(A1:A20,1/(B1:B20)) -- Gary''s Student - gsnu200803 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Divide a range by a corresponding range
Perfect ! Thank You VERY much for your assistance !!
"Gary''s Student" wrote: still use SUMPRODUCT(): =SUMPRODUCT(A1:A20,1/(B1:B20)) -- Gary''s Student - gsnu200803 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Divide a range by a corresponding range
You are quite welcome.
-- Gary''s Student - gsnu200803 "cindyk" wrote: Perfect ! Thank You VERY much for your assistance !! "Gary''s Student" wrote: still use SUMPRODUCT(): =SUMPRODUCT(A1:A20,1/(B1:B20)) -- Gary''s Student - gsnu200803 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Divide a range of cells by a number | Excel Discussion (Misc queries) | |||
| Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
| divide all numbers in range by a fixed number | Excel Discussion (Misc queries) | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Linear Mode
