Sumproduct Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings
In A5 I have the following formula:

=SUMPRODUCT(($E$4:$IV$4<>"hourly")*($E$5:$IV$5))
this works fine until a column is inserted then it be comes
=SUMPRODUCT(($F$4:$IV$4<>"hourly")*($F$5:$IV$5))
How can I change the formula to always sum across the the entire row from
e5:iv5

thanks!
 
Will this work for you?

=SUMPRODUCT((INDIRECT("$E$4:$IV$4")<>"hourly")*INDIRECT("$E$5:$IV$5"))
 
Back
Top