Jul 21 2017 03:39 PM
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?
Jul 22 2017 12:29 AM
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).