| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function Help
Thanks alot, all great suggestions.
"el_horse" wrote: Wahine wrote: Hi there, I have 9 coloumns in a simple spreadsheet that looks like this: if you chabge "x" to 1 (ctrl+h to change cells within a selection) you can use a simple formula (a1:g1) is the percentages and h2 is the amount i2=h2*sumproduct($a1:$g1,a2:g2) and then copy down the formula to h3,h4,... to copy down you can select the h2:hX (where X is the last row you want the formula copied) and press ctrl+d regs el horse |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Need to open the Function Arguments window from VBA for a user defined function. | Excel Programming | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Linear Mode
