microsoft.public.excel.misc

Re: Countif?


Hi Milo,
Am Fri, 6 Apr 2018 20:25:52 +0100 schrieb Milo Bloom:
> Hello, I want to count dates if they are weekday or weekend
> Col A is Dates I.E. 1 Apr 18 to 30 Apr 18
> Col B is Numbers normally 65 to 200
> I want to count the number of weekday and weekend in Col B
try:
=SUMPRODUCT(N(WEEKDAY(A1:A30,2)<6))
or
=SUMPRODUCT(--(WEEKDAY(A1:A31,2)<6),--(A1:A31>0))
for weekdays
and
=SUMPRODUCT(N(WEEKDAY(A1:A30,2)>5))
or
=SUMPRODUCT(--(WEEKDAY(A1:A31,2)>5),--(A1:A31>0))
for weekends
Regards
Claus B.
--
Windows10
Office 2016




Written by Claus Busch 07/04/2018 03:19:55
Check some pics on this site!
18/10/2019 07:57:01