Previous Topic Next Topic

Count if it is monday?

Closed
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.

1 response

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"
0

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

4 responses
how to count sentences in a paragraph..." using c language
gealon2024 -
indhu -

4 responses
counting and stop counting days in a cell
diestra123 -
diestra123 -

4 responses
Counting number of times a value appears if..
jensorr -
sambr22 -

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

3 responses