On Thursday, January 24, 2013 3:26:11 PM UTC-6, Claus Busch wrote:
Hi,



Am Thu, 24 Jan 2013 13:04:32 -0800 (PST) schrieb Cortez:



I should have been more clear. What I gave you was an example, and your response works for that. However, there are many more than two rows and two columns in the real problem (C1:V20) with much smaller increments than 250 / 2500, and so I can't rely on just a <250 and <2500 I have to specify "between" in some manner.



but your formula

countifs(A1:A5,"=0",A1:A5,"<2500",B1:B5,"=0",B1: B5,"<250")

counts between 0 and 2499 and betwenn 0 and 249. You can also use cell

references for the values so you can change the formula by changing the

values. And you can extend the formula for your other columns.





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

Yes, I found a different error that made me think my original countifs wasn't working. You are right, it did what I needed all along.

Thanks again!

TK