| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with a formula (calculating totals based on individual percentages
"jamesplaw" wrote:
I am currently using the formula (below) in row '29'. The formula is specific to column 'B' for total in 'B29'[....] Currently I am having to retype the formula for each new row I add and I am pretty sure the formula is in a 'bad' format. "=L15(B3*$I$3)+(B4*$I$4)+[....]+(B24*$I$24)+(B25*$I$25)" I don't know what operator is missing after L15, but you might try something like: =L15*SUMPRODUCT(B3:B25,$I$3:$I$25) If you are careful to __insert__ rows after row 3 and before row 25, Excel will adjust the ranges in the formula automagically. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating the totals of a group of cells based on content of oth | Excel Discussion (Misc queries) | |||
| Calculating percentages based on the number of checked boxes in a column | Excel Worksheet Functions | |||
| Calculating percentages based on the number of checked boxes in a column | Excel Discussion (Misc queries) | |||
| Calculating percentages based on a single cell | Excel Discussion (Misc queries) | |||
| Need formula for calculating totals to range by using multiple cel | Excel Programming | |||
![joeu2004[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
