| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there a simpler way to do this formula?
=(F16*J16)+(F17*J17)+(F18*J18)+(F19*J19)+(F20*J20) +(F21*J21)+(F22*J22)+(F23*J23)+(F24*J24)+(F25*J25) +(F26*J26)+(F27*J27)+(F28*J28)+(F29*J29)+(F30*J30) +(F31*J31)+(F32*J32)+(F33*J33)+(F34*J34)+(F35*J35) +(F36*J36)+(F37*J37)+(F38*J38)+(F39*J39)+(F40*J40)
first day back from maternity leave and my brain is not quite in excel mode yet! an easier way must be out there, i just can't figure it out. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is there a simpler way to do this formula?
Jenna wrote:
=(F16*J16)+(F17*J17)+(F18*J18)+(F19*J19)+(F20*J20) +(F21*J21)+(F22*J22)+(F23*J23)+(F24*J24)+(F25*J25) +(F26*J26)+(F27*J27)+(F28*J28)+(F29*J29)+(F30*J30) +(F31*J31)+(F32*J32)+(F33*J33)+(F34*J34)+(F35*J35) +(F36*J36)+(F37*J37)+(F38*J38)+(F39*J39)+(F40*J40) first day back from maternity leave and my brain is not quite in excel mode yet! an easier way must be out there, i just can't figure it out. =SUMPRODUCT(F16:F40*J16:J40) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is there a simpler way to do this formula?
=sumproduct(f16:f40,j16:j40)
I didn't see any rows skipped in your formula, right? Jenna wrote: =(F16*J16)+(F17*J17)+(F18*J18)+(F19*J19)+(F20*J20) +(F21*J21)+(F22*J22)+(F23*J23)+(F24*J24)+(F25*J25) +(F26*J26)+(F27*J27)+(F28*J28)+(F29*J29)+(F30*J30) +(F31*J31)+(F32*J32)+(F33*J33)+(F34*J34)+(F35*J35) +(F36*J36)+(F37*J37)+(F38*J38)+(F39*J39)+(F40*J40) first day back from maternity leave and my brain is not quite in excel mode yet! an easier way must be out there, i just can't figure it out. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is there a simpler way to do this formula?
Jenna wrote:
=(F16*J16)+(F17*J17)+(F18*J18)+(F19*J19)+(F20*J20) +(F21*J21)+(F22*J22)+(F23*J23)+(F24*J24)+(F25*J25) +(F26*J26)+(F27*J27)+(F28*J28)+(F29*J29)+(F30*J30) +(F31*J31)+(F32*J32)+(F33*J33)+(F34*J34)+(F35*J35) +(F36*J36)+(F37*J37)+(F38*J38)+(F39*J39)+(F40*J40) first day back from maternity leave and my brain is not quite in excel mode yet! an easier way must be out there, i just can't figure it out. Or, the array formula (commit with CTRL+SHIFT+ENTER): =SUM(F16:F40*J16:J40) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is there a simpler way to do this formula?
How about
=SUMPRODUCT(F16:F40,J16:J40) "Jenna" wrote: =(F16*J16)+(F17*J17)+(F18*J18)+(F19*J19)+(F20*J20) +(F21*J21)+(F22*J22)+(F23*J23)+(F24*J24)+(F25*J25) +(F26*J26)+(F27*J27)+(F28*J28)+(F29*J29)+(F30*J30) +(F31*J31)+(F32*J32)+(F33*J33)+(F34*J34)+(F35*J35) +(F36*J36)+(F37*J37)+(F38*J38)+(F39*J39)+(F40*J40) first day back from maternity leave and my brain is not quite in excel mode yet! an easier way must be out there, i just can't figure it out. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is there a simpler way to do this formula?
Much simpler!! Thank you!!
"JLatham" wrote: How about =SUMPRODUCT(F16:F40,J16:J40) "Jenna" wrote: =(F16*J16)+(F17*J17)+(F18*J18)+(F19*J19)+(F20*J20) +(F21*J21)+(F22*J22)+(F23*J23)+(F24*J24)+(F25*J25) +(F26*J26)+(F27*J27)+(F28*J28)+(F29*J29)+(F30*J30) +(F31*J31)+(F32*J32)+(F33*J33)+(F34*J34)+(F35*J35) +(F36*J36)+(F37*J37)+(F38*J38)+(F39*J39)+(F40*J40) first day back from maternity leave and my brain is not quite in excel mode yet! an easier way must be out there, i just can't figure it out. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA code simpler? | Excel Discussion (Misc queries) | |||
| Simpler Formula ... 2nd lowest value? | Excel Worksheet Functions | |||
| Complex formula vs. simpler | Excel Worksheet Functions | |||
| A SIMPLER FORMULA TO GET A REFERENCE OF WHICH COLUMN IS POPULATED | Excel Worksheet Functions | |||
| Excel should have a simpler subtraction formula similar to "sum". | Excel Worksheet Functions | |||
Linear Mode
