2 conditions Countif with offset
this formula on sheet2 will count the number of D's in row 11 if row 9 has a 1
in it
=SUMPRODUCT(--(Sheet1!E9:IV9=1),--(Sheet1!E11:IV11="D"))
--
Gary
"St@cy" wrote in message
...
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
|