Help With Excel
Closed
Soup
-
Sep 9, 2009 at 03:57 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 12, 2009 at 12:56 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 12, 2009 at 12:56 AM
Related:
- Help With Excel
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- How to take screenshot in excel - Guide
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Sep 12, 2009 at 12:56 AM
Sep 12, 2009 at 12:56 AM
Try the formula
=SUM((A1:A19<=$D$5)*(A1:A19>=$D$4)*(B1:B19)) Press CTRL + SHIFT + ENTER To enter the formula
where A1:A19- dates
D5 - end date
D4 start date
B1:B19 - Your values
=SUM((A1:A19<=$D$5)*(A1:A19>=$D$4)*(B1:B19)) Press CTRL + SHIFT + ENTER To enter the formula
where A1:A19- dates
D5 - end date
D4 start date
B1:B19 - Your values