Change fixed date in formula to a cell location with a changable date
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
Assuming your start and end dates are in C1 and C2, then:
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Top man, thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks