COUNTIF within date ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I wish to find out how many times"1.8" appears (column 'J') each week this
year using dates in column 'B'.
I have a formula which returns the total number of entries for a given week,
but I wish to split this down into its constituent parts for each week.

Current formula:
SUMPRODUCT(--(1+INT((B$8:B$9997-(DATE(YEAR(B$8:B$9997),1,2)-WEEKDAY(DATE(YEAR(B$8:B$9997),1,1))))/7)=22))

This returns the total no. of entries for week 22

Any ideas?
 
I have a formula which returns the total number of entries for a given week,
but I wish to split this down into its constituent parts for each week.
Click to expand...
Any ideas?
Click to expand...

Have you tried asking on microsoft.public.excel.worksheet.functions?
 
Back
Top