for further help, please post a sample workbook.

the COUNTIF formula counts the days, ir doesn't sum them.