Hi,

Am Thu, 24 Jan 2013 12:29:18 -0800 (PST) schrieb Cortez:

A
2000.00
2500.00
1500.00
500.00
3000.00

B
100.00
200.00
0.00
100.00
400.00

I want to be able to count the number of people who satisfy the following criteria:
C1: Account Balance < 2500 and Deposits < 250
C2: Account Balance = 2500 and Deposits < 250
D1: Account Balance < 2500 and Deposits = 250
D2: Account Balance = 2500 and Deposits = 250

for C1 try:
=COUNTIFS(A1:A5,"<2500",B1:B5,"<250")
or
=SUMPRODUCT(--(A1:A5<2500),--(B1:B5<250))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2