Thread: SUMIF within date range as a function of today()'s date
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer bpeltzer is offline
external usenet poster
  
Posts: 180
Default SUMIF within date range as a function of today()'s date


"irvine79" wrote:

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!
Reply With QuoteReply With Quote