How to combine using COUNT "URGENT"

L

LIZZIE

Example:
I want to be able to count how many are 0_F from Column A and III fro
Column D. I can't figure how to enter the function correctly. Th
answer should be 2. I don't know how to combine information from
different ranges.

=COUNT(a1:13,"0_F") and =COUNT(D1:D13,"III")

0_F 1 3 IV
0_F 1 3 III
1 3 IV
0_F 1 3 II
1 3 III
0_F 1 3 II
0_F 2 3 I
0_F 1 3 II
0_F 2 3
0_F 1 3 III
0_F 2 3
0_F 1 3 I
0_R 1 3 II
 
E

Eamon

Try using COUNTIF instead of count...

=COUNTIF(A4:A8,"0_F")
=COUNTIF(D4:D8,"III")

Then sum the result
 
B

Bernard Liengme

Your formula will not necessarily give the correct answer.
Suppose we have in A and D
0_F xxx
2_F III
0_F xxx
0_F xxx

Your formula will return the 3 +1 = 4 but only one row satisfies the
requirement that the cell in A = "0_F" while the corresponding cell in
D="III"

Best wishes
 
T

tsides

These array formulas are confusing but cool:

Enter the following:
=SUM(IF(A1:A13="0_F",IF(D1:D13="III",1)))
and press Ctrl-Shift-Enter instead of just plain Enter
 
Top