is there a simpler way to do this formula?
in [Functions]
|
Prev: calculate hours
Next: Blank space
From: Jenna on 1 Mar 2010 17:13 =(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.
From: Glenn on 1 Mar 2010 17:22 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)
From: Dave Peterson on 1 Mar 2010 17:23 =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
From: Glenn on 1 Mar 2010 17:23 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)
From: JLatham on 1 Mar 2010 17:29
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. |