Multi-demensional frequency distribution
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
|