Sumproduct Help

[Steve]

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!

 

[Ron Coderre]

Will this work for you?

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

 

[Steve]

Like a champ.
Thanks