SUMIF within date range as a function of today()'s date
Figured it out, I just had to subtract the cummulative annual figure prior to
the first of the month from the total annual figure to date.
the formula:
=SUMIF(A3:A262,"<"&TODAY(),Q3:Q262)-SUMIF(A3:A262,"<"&DATE(YEAR(TODAY()),MONTH(TODAY() ),1),Q3:Q262)
"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!
|