Count if it is monday?
Closed
serdargurlek
-
Jul 11, 2016 at 05:17 AM
tunnde80 Posts 2 Registration date Monday July 11, 2016 Status Member Last seen July 18, 2016 - Jul 11, 2016 at 08:42 AM
tunnde80 Posts 2 Registration date Monday July 11, 2016 Status Member Last seen July 18, 2016 - Jul 11, 2016 at 08:42 AM
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.
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.
Related:
- Count if it is monday?
- How to count names in excel - Guide
- Count occurrences in excel - Guide
- Do chats count towards best friends on snapchat 2023 - Guide
- Monday - Download - Organisation and teamwork
- Best time to post on tiktok monday - TikTok Forum
1 response
tunnde80
Posts
2
Registration date
Monday July 11, 2016
Status
Member
Last seen
July 18, 2016
Jul 11, 2016 at 08:42 AM
Jul 11, 2016 at 08:42 AM
Serdargurlek: the date u said , is it "days" or "date"