SUMIF within date range as a function of today()'s date
You've basically got it right... something like
=sumif(a:a,"<="&today(),q:q)-sumif(a:a,"<"&(today()-day(today()+1),q:q). The
logic is add up all the goals for today or earlier, and subtract all the
goals from prior to this month. today()-day(today()) gets you the last day
of the prior month, so adding one gets you the first day of this month. If
you're interested in a particular date other than today, just change today()
in the formula to a cell containing the date of interest.
"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!
|