For the total to date this month try:

=SUM((MONTH(A1:A1000)=MONTH(TODAY()))*Q1:Q1000)

This is an array formula so it must be entered with Crtl + Shift + Enter not
just a simple Enter

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"irvine79" wrote in message
...
Column A = Each day's date for this year
Column Q = Each day's production goal.

I am trying to come up with a cell that will look at today's date and sum
the production goal figures between today and the 1st of the month.

I'm thinking I need to summarize the production goals prior to the 1st,
then
subtract that figure from the YTD figure.

Thanks!