Why is this "COUNTIF" formula returning 0?

[Peter h]

Can someone please tell me what I'm doing wrong here?

=COUNTIF(Revert!F:F,Revert!C:C>EOMONTH(A10,-1))

I want to count all rows on my "Revert" sheet that are after the date in A10. So if I have the date 9/1/18 in A10, it should count all rows that have a date of 9/1 to the present day.

Edit:I did this test to make sure it would work, and it did come back true, so it should count it.
=IF(Revert!C2>EOMONTH(A10,-1),"It is greater","It is not greater")

Thanks.

 

[Aladin Akyurek]

=COUNTIF(Revert!C:C,">"EOMONTH(A10,-1))

is perhaps what you mean?

 

[Peter h]

=COUNTIF(Revert!C:C,">"EOMONTH(A10,-1))

is perhaps what you mean?

Thank You.

 

[Aladin Akyurek]

Thank You.

You are welcome. We are missing the & bit
that formula needs:


=COUNTIF(Revert!C:C,">"&EOMONTH(A10,-1))

 

[Peter h]

You are welcome. We are missing the & bit
that formula needs:


=COUNTIF(Revert!C:C,">"&EOMONTH(A10,-1))

Ya, I noticed that, and adjusted it. Just had forgotten to mention it.

How would I adjust the formula to do a count of all cells in a range, depending on whether or not the cell in "C" fit the criteria? I was thinking something like,

=COUNTIF(Other!E:K,Other!C:C&">"&EOMONTH(A10,-1))

I thought that would work, but it returns 0.

Formulas are way more tricky to me than vba code... lol.

 

[Aladin Akyurek]

What do you have in E:K, text?

 

[Peter h]

What do you have in E:K, text?

No. There are numeric values. Some cells have data, and others are blank in that range, so I'm trying to count how many cells have data. If I do a test formula ( =COUNT(E:K) ) it returns 1,964. So, the count function works, I just wanted to be able to manipulate the countif so that it only counts the rows that meet my criteria.

 

[Aladin Akyurek]

No. There are numeric values. Some cells have data, and others are blank in that range, so I'm trying to count how many cells have data. If I do a test formula ( =COUNT(E:K) ) it returns 1,964. So, the count function works, I just wanted to be able to manipulate the countif so that it only counts the rows that meet my criteria.

Control+shift+enter, not just enter:

=SUM(IF(Other!C$2:C$2000>EOMONTH(A10,-1),IF(ISNUMBER(Other!E$2:K$2000),1)))