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?
--
tia

Jock