Need help with Sumproduct formulas to exclude specific text/values in count and total

Hi,

Can't attach the the file to the post as there is no option to do so which I need help with but this is where the file is located: https://trumpexcel.com/excel-leave-tracker/

What I want to change in this file is to include “IN” and “OFF” on the calendar days that employees are working and have off days but I do not want these words to be counted in the "Leaves This Month", "Leaves This Year" and "Leave Breakup" as leave days. So I want to use it as an work attendance tracker too. All 10 employees have different start days and off days. Which formulas do I need to change please to achieve the aforementioned?

Thank you very much in advance.

cross posted without links:
https://www.mrexcel.com/forum/excel...xclude-specific-text-values-count-totals.html
https://chandoo.org/forum/threads/s...ecific-text-values-in-count-and-totals.42811/
stingx/stingerz, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184