How do i simplify a sumifs function?

[pampitanz]

Hi, I have this formula which works, but it's really long and clunky. how could I possibly simplify it?

=(SUMIFS( K70:AJ70,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K71:AJ71,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K72:AJ72,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K73:AJ73,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K74:AJ74,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K75:AJ75,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K76:AJ76,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K77:AJ77,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K78:AJ78,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K79:AJ79,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K80:AJ80,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K81:AJ81,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K82:AJ82,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K83:AJ83,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K84:AJ84,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K85:AJ85,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K86:AJ86,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K87:AJ87,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K88:AJ88,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K89:AJ89,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K90:AJ90,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K91:AJ91,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K92:AJ92,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K93:AJ93,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K94:AJ94,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K95:AJ95,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K96:AJ96,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1)))+
(SUMIFS( K97:AJ97,$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&('Reference Table'!P1))))

 

[jasonb75]

Perhaps this will do it

=SUM(SUMIFS(OFFSET(K70:AJ70,ROW(K70:K97)-ROW(K70),),$K$11:$AJ$11, ">=1/11/2019",$K$11:$AJ$11, "<"&'Reference Table'!P1))

Array confirmed with Ctrl Shift Enter.

 

[Peter_SSs]

.. or this?

=SUMPRODUCT((K11:AJ11>=DATE(2019,11,1))*(K11:AJ11<'Reference Table'!P1)*(K70:AJ97))

 

[pampitanz]

you two are geniuses. thank you very much

 

[Peter_SSs]

You're welcome. Glad the suggestions helped.