Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif function
I have a 4 column spreadsheet. Col a = date, Col b = time in, Col c = time
out, Col d = minutes spent. I would like to count all the entries that fall between the hrs of 8:00 AM and 8:59 AM IF there are entries in both column b and c. If there are not entries in both col B and col C, I want to disregard those items. Help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
using the countif function | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
COUNTIF FUNCTION | Excel Worksheet Functions |