weighted sum

[soph]

Hi
I have a template of values corresponding to each 15 min
interval between 8am (08:00) to 5.45pm (17:45). Column A
lists these timesteps (A4-A43). B4 has the first value
for Monday at this time. What I need to do is add an extra
80 to this template total for each day, and have the 80
weighted through the timesteps according to the values
already in place. Can anyone help me with this?
Cheers
Soph

 

[Tom Ogilvy]

in C4
=b4+(B4/Sum($B$4:$B$43))*80

then drag fill down to C43

 

[Guest]

Thanks Tom!!

-----Original Message-----
in C4
=b4+(B4/Sum($B$4:$B$43))*80

then drag fill down to C43

--
Regards,
Tom Ogilvy




.