CODEWITHSUNDEEP
excelsum
user1681664
user1681664

Reputation: 1811

excel sumif function not functioning properly

I am trying to get the sum between two dates, but the sumif function is doing it wrong. The answer is suppose to be 18, but it gives me 31. What am I doing wrong? please see picture below:

enter image description here

Upvotes: 0

Views: 80

Answers (1)

user1681664
user1681664

Reputation: 1811

The formula didn't detect the dates because the data was formatted as a string. That's what caused the wrong result.

Upvotes: 1

Related Questions