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

 

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?

Need Help

1 Reply

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