Sumif Function showing a 'Zero" value everytime
Hi,
I am having a problem in calculating the revenue between two month ranges from a drop down list. I am getting a value as 'Zero' for every selection.
I am attaching a sample excel file here.
Any kind of help to resolve this issue is highly appreciated.
All of your months are text strings. You can't do date comparisons by using strings.
I have converted your data to true dates and now it works.
Re: Sumif Function showing a 'Zero" value everytime
Thank you Jeff. I corrected the format of these text strings to dates in my actual file and it works!
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.
Hi, as this was my first time posting a question in this forum so didn't know the rules.
Thanks for guiding me.
A good practice when joining any online discussion board is to read its rules before you post anything. Marking SOLVED is not a rule, but we do ask people to do it as a courtesy to others.
Please take the time to review our rules. There aren't many, and they are all important.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks