Forum Discussion

Perry Rakhra's avatar
Perry Rakhra
Copper Contributor
Jul 21, 2017

SUMIFS or COUNTIFS Bug?

I've been using a SUMIF and COUNTIF function to count the number of times months occur. My reference formula is this:   =COUNTIF('PNL'!$F2:$F189,"Sep 2018")+COUNTIF('Misc'!$F2:$F189,"Sep 2018")   ...
Need Help
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jul 22, 2017

Hi

 

Perry Rakhra wrote:

In conculsion, the function above counts both "Sep 2018" and "Sept 2018". What's going on here?

Type Sep 2018 in a cell and Sept 2018 in another cell. Both will be converted to 01.09.2018 shown as Sep 2018.

And here is the catch: COUNTIF() also does type converting (text to number).