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

On Mon, 6 Aug 2007, in microsoft.public.excel.charting,
Jock said:
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?

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

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

Jock


"Del Cotter" wrote:

On Mon, 6 Aug 2007, in microsoft.public.excel.charting,
Jock said:
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?

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.