Counting conditional cells in multiple rows
 

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

Thanks from Seattle!

Counting conditional cells in multiple rows
 

try:

=SUMPRODUCT(--(R2:R100=Condition1),--(D2:D100=condition2))

"RobDuB" wrote:

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

Thanks from Seattle!

Counting conditional cells in multiple rows
 

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.

--
Biff
Microsoft Excel MVP


"RobDuB" wrote in message
...
How do I go about counting cells that meet criteria from row R and row D?

Thanks from Seattle!

Counting conditional cells in multiple rows
 

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" wrote:

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.

--
Biff
Microsoft Excel MVP


"RobDuB" wrote in message
...
How do I go about counting cells that meet criteria from row R and row D?

Thanks from Seattle!

Counting conditional cells in multiple rows
 

Post the *exact* formula you tried.

Also, tell us what your conditions are.

--
Biff
Microsoft Excel MVP


"RobDuB" wrote in message
...
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" wrote:

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.

--
Biff
Microsoft Excel MVP


"RobDuB" wrote in message
...
How do I go about counting cells that meet criteria from row R and row
D?

Thanks from Seattle!