Home

SUMIFS or COUNTIFS Bug?

Highlighted
Perry Rakhra
Occasional Visitor

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

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
20 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies