| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
sum cells
Hi bob
thought that by myself. So there really seems to be a requirement out there for using the original functionality of SUMPRODUCT :-) -- Regards Frank Kabel Frankfurt, Germany Bob Phillips wrote: Hi Frank, A normal SUMPRODUCT, a real rarity! "Frank Kabel" wrote in message ... Hi try =SUMPRODUCT(E10:E1000,Z10:Z1000) -- Regards Frank Kabel Frankfurt, Germany bob engler wrote: 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
