Sumifs and Countifs

%3CLINGO-SUB%20id%3D%22lingo-sub-2650174%22%20slang%3D%22en-US%22%3ESumifs%20and%20Countifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2650174%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E.i%20have%20this%20weird%20problem%20where%20I%20have%20placed%20a%20value%20of%201%20or%200%20in%20a%20particular%20column%20based%20on%20a%20logical%20condition%2C%20however%20it%20always%20ads%20or%20counts%20more%20values%20than%20it%20should.%3CBR%20%2F%3E%3CBR%20%2F%3EManually%20if%20I%20add%2C%20the%20number%20of%20%221's%22%20In%20d%20column%20is%20300.%3CBR%20%2F%3EHowever%2C%20when%20I%20do%20a%20sum%20or%20sumif%20or%20countif%2C%20d%20result%20comes%20as%20303.%20Where%20is%20extra%203%20coming%20from%3F%20How%20can%20I%20fix%20it%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2650174%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2650205%22%20slang%3D%22en-US%22%3ERe%3A%20Sumifs%20and%20Countifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2650205%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1128927%22%20target%3D%22_blank%22%3E%40Jipin_daiki%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20would%20help%20if%20you%20could%20attach%20a%20sample%20workbook%20without%20sensitive%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hi,
.i have this weird problem where I have placed a value of 1 or 0 in a particular column based on a logical condition, however it always ads or counts more values than it should.

Manually if I add, the number of "1's" In d column is 300.
However, when I do a sum or sumif or countif, d result comes as 303. Where is extra 3 coming from? How can I fix it?
1 Reply

@Jipin_daiki 

It would help if you could attach a sample workbook without sensitive data.