Let's say I have a Formula that uses a date range used in cell D4
=SUMIFS(G:G,B:B,"Apples",A:A,">"&DATE(2011,5,1),A:A,"<="&DATE(2011,5,31))
If I want to use the same formula in D5, but now need to show DATE(2011,6,1),A:A,"<="&DATE(2011,6,30))
How can I do this without having to rewrite the formula over and over in D6, D7. D8. etc.....
Cell Selection
Is it possible to write an if/then statement from one worksheet to another worksheet where the if column A Sheet1and row 12 Sheet1 then add value of the cell matching to Sheet2. See attached example.
Bookmarks