Microsoft Excel Question: Download Questions PDF
I have a spreadsheet where I want to sum cells from column E if the corresponding date in column A is within the last 60 days?
Answer:
First, I set up a cell in an out-of-the-way section of the worksheet. In cell Z1, enter the formula:
=now()-60
This formula calculates a day which is 60 days prior to today.
Then, the formula you want in cell E101 is: =sumif(A1:A100,">"&$Z$1,E1:E100)
=now()-60
This formula calculates a day which is 60 days prior to today.
Then, the formula you want in cell E101 is: =sumif(A1:A100,">"&$Z$1,E1:E100)
Download MS Excel Interview Questions And Answers
PDF