How to combine using COUNT "URGENT"

[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(D113,"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

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(A1:A13="0_F"),--(D113="III"))

 

[Eamon]

Try using COUNTIF instead of count...

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

Then sum the result

 

[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

 

[tsides]

These array formulas are confusing but cool:

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