Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Operator is in excel cells, how to reference it
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using cell reference with logical operator in DGET expression | Excel Worksheet Functions | |||
How to use union reference operator? | Excel Discussion (Misc queries) | |||
Reference an Operator from a cell with Sumproduct | Excel Worksheet Functions | |||
Why doesnt union reference operator work with COUNTIF? | Excel Discussion (Misc queries) | |||
How to use a cell value as operator in a worksheet reference? | Excel Worksheet Functions |