Ben

I'm not finding it easy to visualize exactly how you have your data
organised, but if it's a case of eg in column B you have your
individual production totals *and* your daily production totals (ie a
summation of the individual production totals) then you have basically
doubled up on the values, so one way to get the YTD would be:

=SUM(B:B)/2

Obviusly you can adjust the range to suit.

Is this what you meant, or have I missed the point?

Best regards

Richard


--
RichardSchollar
------------------------------------------------------------------------
RichardSchollar's Profile: http://www.officehelp.in/member.php?userid=5248
View this thread: http://www.officehelp.in/showthread.php?t=1271098

Posted from - http://www.officehelp.in