COUNTIF within date ranges

[Jock]

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?

 

[Del Cotter]

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.

Any ideas?

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

 

[Jock]

Yeah, I did after I realised I'd posted this on the wrong blog! Thx