J
J.Scargill
Hi guys,
Need some help with a formula please. Have tried myself and know that the
answer is straightforward but going through a mental block!
Col Q Col R
A01 58
A01 62
P02 62
Both columns data starts in cell 14 and runs down to cell 10000.
I need to count the entries in Column Q that = A01 ONLY IF Col R = 62. Then
do the same for Q = A01 ONLY IF R = 58, and so on. The worksheet is a
year-to-date file and will be updated weekly with many entries in both
columns with varying values.
Many thanks.
Need some help with a formula please. Have tried myself and know that the
answer is straightforward but going through a mental block!
Col Q Col R
A01 58
A01 62
P02 62
Both columns data starts in cell 14 and runs down to cell 10000.
I need to count the entries in Column Q that = A01 ONLY IF Col R = 62. Then
do the same for Q = A01 ONLY IF R = 58, and so on. The worksheet is a
year-to-date file and will be updated weekly with many entries in both
columns with varying values.
Many thanks.