Count if it is monday? [Closed]

Question

Count if it is monday? [Closed]

Report

serdargurlek - Jul 11, 2016 at 05:17 AM
tunnde80

Posts: 3
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.

Count if it is monday?
How to count date cells for monday of this week ✓ - Forum - Excel
How do i count a list of names in excel? - How-To - Excel
Stop counting days in excel when status is changed ✓ - Forum - Excel
Tiktok live count - How-To - TikTok
How to hide subscriber counts on youtube - How-To - YouTube

1 reply

Ask a question

tunnde80 · Answer 1 · 2016-07-11T08:42:04-0400

Answer 1 / 1

tunnde80

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

Jul 11, 2016 at 08:42 AM

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

Count if it is monday? [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!