auto fill

[AJThomas01]

Hi there,

I have the following formula in a cell

=SUMIFS('A3 Strategic Report_REV002.xlsx'!Actual_Downtime,Type,"=BREA",Site,"=Long",Month,"=1",Year,"=2010")

I would like to autofill this formula down to Month 12, currently I have to change month to 2 etc i.e.
=SUMIFS('A3 Strategic Report_REV002.xlsx'!Actual_Downtime,Type,"=BREA",Site,"=Long",Month,"=2",Year,"=2010")

 

[Richard Schollar]

Hi

Copy this formula down:

=SUMIFS('A3 Strategic Report_REV002.xlsx'!Actual_Downtime,Type,"=BREA",Site,"=Long",Month,ROWS($A$1:$A1),Year,"=2010")

 

[AJThomas01]

You are a genius, thank you very much