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)

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
I want to add 25 to all of the cells in column A. I do not want a new column, I want to add it right to the cells in column A?I use a large spreadsheet on a daily basis with 31 worksheets (one for each day of the month). Each worksheet is huge.I would like to insert another sheet in the workbook and insert a button to copy another worksheet to the end of the workbook and then rename the sheet to the correspondingday of the month?