2 formulas needed for=COUNTIF based on dates

**excelteam777** · 11-15-2013, 06:18 PM

I would like to count only when "yes" is entered into a cell and to do so on a 24 hour time table with the totals resetting to "0" when a new day starts.
Also would like to do the same in another total it for the month based on a date format of 11/15/13 from another cell.

1st: Hour formula:

B24 = formula
C29 = where "yes" or 'No" will be entered

count on a 24hour time table only when "yes" is entered.

2nd: Monthly Formula:

Q4 = Formula
B29 = Date (format is 11/15/13) however if that needs to change let me know.
C29 = where "yes" or 'No" will be entered

count when "yes" is entered for that particular month

Can someone help with either of these?????

Thanks

**excelteam777** · 11-15-2013, 09:51 PM

can anyone offer any help with this?

**NU2vba** · 11-15-2013, 10:45 PM

a sample workbook would really help but I'll try taking a stab at it...

If you're only trying to count "YES" in column C for hour formula, then try =COUNTIF(C:C,"YES")

For monthly formula, try =COUNTIFS(C:C,"YES", B:B,"11/15/13")

HTH =)

**kmahesh** · 11-16-2013, 12:17 AM

Hello excelteam777,

Can you pls upload a sample workbook with details as to what you will enter where and what are
your expected results.
Aslo what do you mean by date format 11/15/13 do you mean mm/dd/yy ?