Counting conditional cells in multiple rows

[Guest]

How do I go about counting cells that meet criteria from row R and row D?

Thanks from Seattle!

 

[Guest]

try:

=SUMPRODUCT(--(R2:R100=Condition1),--(D2100=condition2))

 

[T. Valko]

Do you mean columns D and R?

......D.....R
1...x......1
2...y......1
3...x......2
4...x......1
5...y......1

To return the count where column D = x and column R =1:

=SUMPRODUCT(--(D15="x"),--(R1:R5=1))

Result = 2

Note that you can't use entire columns as range references with SUMPRODUCT
unless you're using Excel 2007.

 

[Guest]

Thank you for your help. We seem on the right path, yet I am receiving a
"#VALUE" reading. I am using Excel 2003 and have limited the columns to a
specific row count. Any ideas how to correct the error?

Thanks again!

 

[T. Valko]

Post the *exact* formula you tried.

Also, tell us what your conditions are.