Forum Discussion
Formula help VLOOKUP? MATCH? INDEX>
HansVogelaar here is a sample - Sheet 2, Column Z has an example of what I want to see and be able to copy across to other dates. Sheet A currently has just one year and location but I think that is enough to solve the problem with.
This should work in Z3:
=SUMIFS(_2019__7[[Column2]:[Column2]],_2019__7[[Column1]:[Column1]],$A3,_2019__7[[Column3]:[Column3]],Z$1)
This can be filled to the right. See the attached version.
The idea is from Absolute Structured References in Excel Table Formulas
HansVogelaar thanks again for your help!! It works great!
karenynp Why not use a pivot table. Your data is perfectly structured for it. No need for formulae and you can easily adopt the tables when you enter data for more than one year and/or location.
See attached.
