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
Bookmarks