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
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- Screenshot in excel - Guide
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
1 reply
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