I have an issue with SUMIFS. I have a range of data on one sheet, and then on another sheet I am pulling data by date, and summing the totals. It is for commission calculation, basically trying to determine earnings by month. The worksheet is returning a value for 3/31/2018 that does not exist. I have tried deleting and re-inputting the date column with no luck. It is reading a combination of cells and summing them as if they occurred on 3/31.
Solved by O. F. in 22 mins