Limited use of =Countifs ?

[Captain Randy]

When working with =Countifs(B1:B52,B60,C1:C52,D61)
Is there a limlit as to how many rows and columns you can use for this Formula?

If not what kind of simple mistake seems to be the most common ones made?

This formula works great until I get more then three items typed in.
(items being; B1:B52,B60) B1:B52 look in column, B60 looking for this item in B1:B52.

Any help from some of the pros would sure be "WELCOME"

Thank You in Advance
Randy,

 

[T. Valko]

Hello T Valko
You said in your last post,
"The cells in that range can notYou're also testing the same range twice for different criteria:

$F$1:$F$52,"L70"
$F$1:$F$52,"M$70"

be equal to both criteria at the same time." <!-- / message --><!-- sig -->

Let me ask you, once all of the criteria's are meet, is there a WAY I can add what is on the same line that the criteria's are met ?
I attemped to add =countifs(And( in the front of the code, but that made of a mess.

Once I followed your advice and dropping the last criteria ($f$1:$f$52,L70)
Every thing works great!

But the last most important info is at the end of the criteria which comes from F row.
In your wisdom is there a way I can add this last row?

Thank You, very much for your help.
Randy

If you want to test a single range for more than one condition just tell us what the conditions are.

You can test for an "OR" condition such as: F1:F10 = X or Y

You can test for an "AND" condition such as: F1:F10 >=10 and <=20.