Related:
- Excel Formula Counting Diff IF
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Percentage formula in excel marksheet - Guide
- Excel color formula - Guide
- Excel mod apk for pc - Download - Spreadsheets
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Oct 21, 2009 at 07:23 AM
Oct 21, 2009 at 07:23 AM
Try this
=sum(COUNTIF(A5:A106,"<=" & +D2)*COUNTIF(F5:F106,"AM"))-sum(COUNTIF(A5:A106,"<" & DATE(2009,1,1)) *COUNTIF(F5:F106,"AM"))
Press CTRL +SHIFT+ENTER To enter the formula
=sum(COUNTIF(A5:A106,"<=" & +D2)*COUNTIF(F5:F106,"AM"))-sum(COUNTIF(A5:A106,"<" & DATE(2009,1,1)) *COUNTIF(F5:F106,"AM"))
Press CTRL +SHIFT+ENTER To enter the formula
Nov 2, 2009 at 01:23 PM
Nov 6, 2009 at 07:23 AM
Nov 6, 2009 at 10:01 AM