| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sum cells
I have a WS that has counts in cells E10 to E209 that are multiplied
by data in cells Z10 to Z209. Now I do E10*$Z10 in AZ10 that is repeated thru AA209. Then I do =SUM(AA10:AA209) in cell E45. The same thing is done for columns (F to P * Z) and AB to AL put in F45 to P45. Is there a way to eliminate the AA to AL cells and sum the data directly into the row 45 columns ( like =SUM(E10*$Z10:E209*$Z209) which doesn't work)? Thanks..... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
| Compare 1 cell to column of cells returning adjacent cells info? | Excel Worksheet Functions | |||
| Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
Threaded Mode
