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?
Submitted by: AdministratorFirst, 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)
Submitted by: Administrator
=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)
Submitted by: Administrator
Read Online Microsoft Excel Job Interview Questions And Answers
Top Microsoft Excel Questions
| ☺ | What are Excel Spreadsheet Number Formats? |
| ☺ | Using Excel is there a way to close all open Excel files at once instead of closing them one at a time? |
| ☺ | How do I combine different chart types into my Excel spreadsheet? |
| ☺ | In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format? |
| ☺ | How to Change the Sheet Tab Color of Excel Spreadsheets? |
Top Application Program Categories
| ☺ | AutoCAD Interview Questions. |
| ☺ | Microsoft Office Interview Questions. |
| ☺ | Microsoft Outlook Interview Questions. |
| ☺ | Microsoft Excel Interview Questions. |
| ☺ | WPF Interview Questions. |
