Sanjeev06 New Member Dec 2, 2014 #1 when i sum against a criteria like >10 Days its not working please suggest
A Ajesh Active Member Dec 2, 2014 #3 A sample file would be helpful, however are you try ">10" in your criteria field where Criteria range is number of days. Thanks
A sample file would be helpful, however are you try ">10" in your criteria field where Criteria range is number of days. Thanks
Syedali Active Member Dec 3, 2014 #4 Hi Sanjeev, PFA, your requirement completed. Attachments SUMIFS-SAMPLE.xlsx SUMIFS-SAMPLE.xlsx 9.5 KB · Views: 9