Previous Topic Next Topic

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

Answer 1 / 1
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"
Ask a question