Count if it is monday? [Closed]

Report
-
Posts
3
Registration date
Monday July 11, 2016
Status
Member
Last seen
July 18, 2016
-
Hey all; I could not manage to work this out after 1 day research and try my chance here.

I have dates on column A and numbers (both positive,negative and blank cells) at column B.

I want to count how many positive numbers at column B when it is monday .

=COUNTIFS(A2:A999;"Monday";B2:B999;">0") gives a 0 result I dont know why. Thanks.

1 reply

Posts
3
Registration date
Monday July 11, 2016
Status
Member
Last seen
July 18, 2016

Serdargurlek: the date u said , is it "days" or "date"

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!