Sumproduct Help
 

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")*IND IRECT("$E$5:$IV$5"))

--
Regards,
Ron

Like a champ.
Thanks

"Ron Coderre" wrote:

Will this work for you?

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

--
Regards,
Ron