Monday 15 July 2013

sum - excel sumif function not functioning properly -


I am trying to get the amount between two dates, but the sumif function is doing wrong. The answer can be 18, but it gives me 31. What am I doing wrong? Please see the image below:

Enter image details here

The formula date was not detected because the data was formatted as a string. For this reason the result is false.

No comments:

Post a Comment