Hi

I have the below formula and I need to change the fixed date ranges in the formula to cell locations so that I can vary the dates, can anyone help me out?


=SUMIFS(Downtime!F2:F10000,Downtime!B2:B10000,"Machine1",Downtime!G2:G10000,"1",Downtime!A2:A10000,">=01/01/2013",Downtime!A2:A10000,"<=31/08/2013")

Cheers

Carl