H
Hemant
I would appreciate help in resolving the following problem
Column A ColumnB Column C Column D
r1 y04 y 1
r2 y03 y 1
r3 y04 n 0
r4 y03 n 0
r5 y04 y 1
I have been able to us the following formula on column D for counting with
"y04"
sumif(b1:b5,"y04",d1:d5) -> results in answer 2
Is there a way of using data in column C which is more meaningful
Many thanks in advance
Hemant
Column A ColumnB Column C Column D
r1 y04 y 1
r2 y03 y 1
r3 y04 n 0
r4 y03 n 0
r5 y04 y 1
I have been able to us the following formula on column D for counting with
"y04"
sumif(b1:b5,"y04",d1:d5) -> results in answer 2
Is there a way of using data in column C which is more meaningful
Many thanks in advance
Hemant