SUMIFS or COUNTIFS Bug?

Copper Contributor

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")

 

I made a typo on one of my sheets and wrote "Sept 2018". I noticed however it still counted that occurence.


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

1 Reply

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).