Help With Excel
Closed
Soup
-
9 Sep 2009 à 15:57
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 12 Sep 2009 à 00:56
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 12 Sep 2009 à 00:56
Related:
- Help With Excel
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel marksheet - Guide
- Gif in excel - Guide
1 response
Excelguru
Posts
261
Registration date
Saturday 11 April 2009
Status
Member
Last seen
21 June 2011
307
12 Sep 2009 à 00:56
12 Sep 2009 à 00:56
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