Forum Discussion

beeliew's avatar
beeliew
Copper Contributor
Jan 24, 2026

Not able to count with COUNTIFS

I am having problem counting with COUNTIFS   In a column of an Excel table =TEXT([@[Date: Referral Rx]], "mmmm") This shows the month in the column   Then, I am counting the total of those in t...
excel
Excel on Mac
Olufemi7's avatar
Olufemi7
Iron Contributor
Jan 27, 2026

Hello beeliew​, 

The reason your formula is returning 0 is because COUNTIFS doesn’t evaluate the calculated column with TEXT() properly. When you use =TEXT([@[Date: Referral Rx]], "mmmm"), Excel is storing those as dynamic formulas, not static text values, so the comparison against TEXT(TODAY(),"mmmm") fails.

A better approach is to count directly from the date column instead of relying on the text month column. You can do this with a date-based comparison:

=COUNTIFS(
  Table[Date: Referral Rx], ">=" & EOMONTH(TODAY(),-1)+1,
  Table[Date: Referral Rx], "<=" & EOMONTH(TODAY(),0)
)

This counts all rows where the referral date falls in the current month.

If you prefer to use a helper column, use =MONTH([@[Date: Referral Rx]]) instead of TEXT(), and then compare with MONTH(TODAY()):

=COUNTIFS(Table[MonthNumber], MONTH(TODAY()))

Both methods will give you the correct count for the current month. The date-based version is usually the most reliable since it avoids text conversion issues.