J
Joe M.
I am trying to count the number of occurences which occur in 2 columns using:
=SUMPRODUCT(--('CM(Sched)'!AP:AP="BRKD"),--('CM(Sched)'!S:S=0))
In worksheet CM(Sched) column AP is the text "BRKD". In the same worksheet
column S has either a 0 or 1 (numeric).
S AP
0 DELTA
0 BRKD
1 BRKD
0 BRKD
The result should be 2. I get the error #NUM!. Can someone help?
Thanks,
Joe M.
=SUMPRODUCT(--('CM(Sched)'!AP:AP="BRKD"),--('CM(Sched)'!S:S=0))
In worksheet CM(Sched) column AP is the text "BRKD". In the same worksheet
column S has either a 0 or 1 (numeric).
S AP
0 DELTA
0 BRKD
1 BRKD
0 BRKD
The result should be 2. I get the error #NUM!. Can someone help?
Thanks,
Joe M.