| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal formulas that chooses values
Help. Need formulas to arive at subtotals in column I. For example row 5 is 1 times 4 (value on row 4 above the 1), row 6 is 1 times 2 (value on row 4 above the 1), row 7 is 1 times 1 (value on row 4 above the 1), row 8 is 1 times 3 (value of row 4 above line 1), etc _|_D_|_E_|_F_|_G_|_H_|_I_ 4|_1_|_2_|_3_|_4_|_5_| 5|___|___|___|_1_|___|_5_ 6|___|_1_|___|___|___|_2_ 7|_1_|___|___|___|___|_1_ 8|___|___|_1_|___|___|_3_ Total Score 11 Thanks so very much. mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=504527 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal formulas that chooses values
mikeburg,
In I5 use: =SUMPRODUCT($D$4:$H$4, D5:H5) Then copy down. HTH Kostis Vezerides |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal formulas that chooses values
Works great! Many thanks, mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=504527 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
| How can I show values, not formulas in Excel? | Excel Discussion (Misc queries) | |||
| deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
| Can you copy multiple tabs from formulas to values w/o paste spec? | Excel Worksheet Functions | |||
| Formulas with "Y" & "N" values | Excel Discussion (Misc queries) | |||
Hybrid Mode
