Hi, All:


What I want to accomplish is that I want to summarize the data in the
sheets "data" under some conditions?

For example I want to know how many customers have balance below 4000
and how many of them have balance above 5000, etc

So I have a set of conditions in column B in "summary" sheet, < 4000,

5000

in column C, another variable =0, =1 etc

...........

In column O, is the sum of customers satisfy my conditions in column B
to P.

So I have B2="'< 4000," B3="5000".......

How can I reference them in VBA, for example, I want to check if
Sheets("data").cells(1,1)0
or not. I want to use B2 directly. How can I do that in VBA
I tried

if Sheets("data").cells(1,1) & Sheets("summary").(2, 2) then
..........
end if

It doesn't work. Any one knows how to handle this? Thanks.