Forum Discussion
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...
Olufemi7 , initial formula works fine if done correctly, see Harun24HR example.
Thank you SergeiBaklan for pointing me to Harun24HR example. I see that the initial formula with TEXT() can work if the table column is structured correctly. In my earlier reply I explained why the formula was returning 0 in this case and suggested a date‑based approach as a more reliable alternative.
Microsoft’s documentation confirms that COUNTIFS works best with numeric or date ranges rather than text conversions, which can cause mismatches. For reference, see:
Both methods are valid the TEXT() approach works when implemented properly, and the date‑based comparison is the documented, more robust solution.