Why count ifs formula returns zero

[flare9x]

Hello all

I have this formula:

=COUNTIFS(B3:B23496,"Monday",M3:M23496,"True")

The logic looks correct - however the result is zero.... not sure why

B is text... Monday to Friday.... and then column M is and =if the number is higher than yesterday say true or false...

any ideas?

 

[Aladin Akyurek]

Do you have a formula in column B and/or in column M? If so, care to post any formula that you have?

 

[flare9x]

Do you have a formula in column B and/or in column M? If so, care to post any formula that you have?

Column B formula: =IFERROR(DATE(LEFT(A3,4),MID(A3,5,2),RIGHT(A3,2)),"")

Column M formula: =IF(L5>L4,"True","False")

 

[Aladin Akyurek]

Column B formula: =IFERROR(DATE(LEFT(A3,4),MID(A3,5,2),RIGHT(A3,2)),"")

Column M formula: =IF(L5>L4,"True","False")

Keep B as is; Change M to just:

=L5>L4

Then invoke:

=SUMPRODUCT(--(TEXT(B4:B23496,"dddd")="Monday"),--M4:M23496)

 

[flare9x]

Keep B as is; Change M to just:

=L5>L4

Then invoke:

=SUMPRODUCT(--(TEXT(B4:B23496,"dddd")="Monday"),--M4:M23496)

This is what worked with the original formula:

=IF(L5>L4,TRUE)

Awesome - thanks again!

 

[Aladin Akyurek]

This is what worked with the original formula:

=IF(L5>L4,TRUE)

Awesome - thanks again!

You are welcome.

By the way,

=L5>L5

is a comparison. Such always delivers a truth value, i.e. either TRUE or FALSE. So the surrounding IF is not needed, also for reasons of efficiency.