- Joined
- Jun 23, 2016
- Messages
- 1
- Reaction score
- 0
I am trying to get an annualized sales figure based on YTD sales. I want this to be linked to a today() function so that the spreadsheet only includes figures from today's date or before when calculating the annualized total. I have a table with months and corresponding totals shown below each month (starting in April). And thought I could use a formula including sumif that would tally and annualize all numbers with corresponding months less than or equal to the month from today's date.
Something along the lines of:
=SUMIF(B8:M8,"<=H3",(B10:M10))
B8:M8 was the row of months (April-Mar)
B10-M10 was the row of sales figures from those months
H3 was a "text" formula, extracting the month from a corresponding "today()" formula.
For some reason this only seemed to take the figure from the first month (April). Not sure where I am going wrong?
Any help is appreciated.
Something along the lines of:
=SUMIF(B8:M8,"<=H3",(B10:M10))
B8:M8 was the row of months (April-Mar)
B10-M10 was the row of sales figures from those months
H3 was a "text" formula, extracting the month from a corresponding "today()" formula.
For some reason this only seemed to take the figure from the first month (April). Not sure where I am going wrong?
Any help is appreciated.