Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CountIF formulas
Hello,
I have an excel sheet that contains 2 columns (that are relevant to this topic) Column H:H contains a date formatted: 9/14/2006 2:04:27 PM Column Q:Q contains a job number formatted: 20060914143253. (As you can see the first 8 characters are also the date). Job numbers are unique to the job however if more that one person worked on o job there would be identical job numbers. What I need to do is Count all of the Unique ticket numbers that occurred on a certain day. I think the statement would look something like this: COUNTIF(Job Number is unique AND was created in march) If anyone could help that would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Formulas | Excel Worksheet Functions | |||
COUNTIF and similar formulas | Excel Worksheet Functions | |||
Formulas - Countif and Fill Down | Excel Discussion (Misc queries) | |||
Countif formulas | Excel Discussion (Misc queries) | |||
COUNTIF FORMULAS | Excel Discussion (Misc queries) |