Need Help with a Sum of a Product of a Currency and Product

[tbwhitworth]

Does anyone have a way to simplify this formula and make it so it
automatically includes newly added rows or cells?

=SUM((SUM($K$9:L9)*$H$9),(SUM($K$11:L11)*$H$11),(SUM($K$13:L13)*$H$13),
(SUM($K$15:L15)*$H$15),(SUM($K$17:L17)*$H$17),(SUM($K$19:L19)*$H$19),
(SUM($K$21:L21)*$H$21),(SUM($K$23:L23)*$H$23),(SUM($K$25:L25)*$H$25),
(SUM($K$27:L27)*$H$27),(SUM($K$29:L29)*$H$29),(SUM($K$31:L31)*$H$31),
(SUM($K$33:L33)*$H$33),(SUM($K$35:L35)*$H$35),(SUM($K$37:L37)*$H$37),
(SUM($K$39:L39)*$H$39),(SUM($K$41:L41)*$H$41),(SUM($K$43:L43)*$H$43),
(SUM($K$45:L45)*$H$45),(SUM($K$47:L47)*$H$47),(SUM($K$49:L49)*$H$49),
(SUM($K$51:L51)*$H$51),(SUM($K$53:L53)*$H$53),(SUM($K$55:L55)*$H$55),
(SUM($K$57:L57)*$H$57),(SUM($K$59:L59)*$H$59),(SUM($K$61:L61)*$H$61),
(SUM($K$63:L63)*$H$63),(SUM($K$65:L65)*$H$65),(SUM($K$67:L67)*$H$67))

 

[Peo Sjoblom]

One possible way

=SUMPRODUCT(((MOD(ROW(K9:L67),2)=1)*(K9:L67))*(MOD(ROW(H9:H67),2)=1)*(H9:H67))



--


Regards,


Peo Sjoblom