COUNTIF using WEEKDAY

[Jock]

Hi,
I wish to find out how many times "1.8" (column J) appears each week of the
year. Dates are in column B.
I currently have a formula which returns the total count of entries per week
but I wish to split this down yet further.

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 number of entries for week 22.

Any ideas?

 

[Wigi]

Hi

Like this?

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)*(J$8:J$9997=1.8))

See at the end of the formula.

 

[Jock]

Thanks, that worked ok.


Jock

Hi

Like this?

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)*(J$8:J$9997=1.8))

See at the end of the formula.