Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to count the number of disconnects, "D"s, in for each employee in the
month of x. Each employee info takes a total of five lines. The row indicating the month is two lines above the type, where the "D"s would be located. The formula will be on a different sheet than the data and copied down the column. Please help me with the right functions and/or macro. Example: 'QA Input' D E F .....IV 8 Employee1 9 Month 1 1 3 10 WO# 11 Type D D S .. .. 13 Employee2 14 Month 15 WO# 16 Type |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
Offset/Countif question | Excel Discussion (Misc queries) | |||
Countif from an offset column | Excel Worksheet Functions | |||
Adding an OFFSET condition to a COUNTIF?? | Excel Programming | |||
Offset, Dynamic range, Countif | Excel Discussion (Misc queries) |