Counting conditional cells in multiple rows

R

RobDuB

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

Thanks from Seattle!
 
T

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(--(D1:D5="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.
 
R

RobDuB

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!
 
Top