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?
- 1 Answers
- 763 Views
- I also Faced
- E-Mail Answers
Answer / Ramesh Babu
You can use Excel's COUNTIFS and SUMIFS functions combined with the TODAY() function to achieve this. Here's an example:
1. In an empty cell, enter the following formula: `=SUMIFS(E:E, A:A, "<=TODAY()", E:E, >=AGGREGATE(14,6,E:E, COUNT((A:A<=TODAY()))-ROW(INDIRECT("A1"))+1))`
2. Press Enter and adjust the cell ranges as needed.
| Is This Answer Correct ? | 0 Yes | 0 No |
what filter is used, if more than two conditions are used or if analysis of list has to be done where there are more than two conditions?
How do you make a div 0 0?
How do you count words in excel?
How do I compare two lists in excel for missing data?
How can I get excel to accept an entry like "5+5" without the leading equals sign as a formula? I have done this is the past but can not remember how.?
How do you insert a pivot table in excel?
Is there an ifs function in excel?
What does pi stand for?
How do you sum values?
How do I swap text in excel?
What is the difference between lookup and vlookup?
Can we increase the number of rows in excel?
MS Excel Microsoft 
