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.

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)

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

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)

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.

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.