Previous Topic Next Topic

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
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 response

Answer 1 / 1
tunnde80 Posts 2 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"

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

4 responses
Instagram not updating people I follow total
Rayinado -
HelpiOS -

1 response
best time to publish
Rubens94 -
Rubens94 -

3 responses
Sort by/View only Unread Messages
clydekeep -
artben -

4 responses
Best Time To Post On Instagram
Av8tor1963 -
Av8tor1963 -

3 responses