sumproduct returns incorrect value

Harun24HR Thank you for your reply. I think I did not explain correctly what I need. A user will be inputting data in "Rental #1" sheet in Column C - when guest checking in, in Column E - how many nights guest stayed. Column D automatically calculates check out date. In example below there were 5 check out dates in January and 3 in February. I need in "Variable Expenses" sheet in Column E - formula automatically calculate how many checkout dates were in January (in this example 5) and multiply it by 100. As can be seen in the example below the formula I am currently using is working properly for February (formula also work properly for every other months). But it does not work properly for January and return a value of 14000 instead of 500. Hope it is more clear now 🙂