Hi, I'm trying to get a sum referenced from two worksheets to one. I
have in the "weekly sheet" laborer hours for different jobs, with each
week represented in C3 thru BD3. their hourly wage changes on Z3:BD3
and I'm trying to get this total into the middle (Summary sheet. I have
tried the below formulas with and without the brackets and it keeps
coming up with a value error and upon tracing the problem seems to be at
'Weekly Sheet'!Z3:BD3 entry. I can do the adding and multiplication
on another part of the weekly sheet in two separate cells and then
transfer them over, but it would be easier to do it in one step.

=SUM('Weekly Sheet'!C3:Y3*Prices!$B$2)+('Weekly Sheet'!Z3:BD3*Prices!B10)

=SUM('Weekly Sheet'!C3:Y38*Prices!$B$2+'Weekly Sheet'!Z3:BD3*Prices!$B$10)

=SUM('Weekly Sheet'!C3:Y3)*(Prices!$B$2)+('Weekly
Sheet'!Z3:BD3)*(Prices!$B$10)