HLOOKUP with a rolling end value

[tetter]

I hope i explain my problem correctly

I have a very large file very similar to this

A B C D E F...
01/01/01 01/02/01 01/03/01 01/4/01 01/05/01 etc ...
2 Dogs 2 3 1 1 3
3 Cats 1 2 3 2 1

I use this file to enter our daily numbers. Another tab uses an HLOOKUP formula to pull the current date to be placed in a format for the executive group to view

I want to create a formula that sums the previous fiscal year information with a rolling end date

Ex on 03/01/17 i would want the formula to sum all values on that row from 01/01/16 to 03/01/16
and
on 03/02/17 i would want the formula to sum all values on that row from 01/01/16 to 03/02/16

[Bernie Deitrick]

Use a SUMIFS, like

=SUMIFS(Data!2:2,Data!$1:$1,">=" & DATE(YEAR(A1),1,1),Data!$1:$1,"<=" & A1)

Where your daily numbers are on a sheet named Data, and the end date of interest is in cell A1

[tetter]

you sir, are my hero

thank you