Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I'm running Excel 2002 within a W2K 2000 enviroment and cannot resolve the following cell calculation: I need to take groupings (for example), in column B:B to select a number out of several, lets say it's 14 through 23, and I want all the numbers of 15 to reference a number associated in the same row, but another column (A:A) to give me a count of such numbers. Such as, if b:b has 10 values of 15, but A:A has 0's and 1's. How can I count only the A:A 1's for the B:B 15's in a single cell. I'm at a loss on this one, can anyone help? Thanks!!! Todd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Referencing columns values in row | Excel Discussion (Misc queries) | |||
Referencing rows to columns | Excel Discussion (Misc queries) | |||
Referencing columns to rows | Excel Worksheet Functions | |||
Referencing columns as rows | Excel Discussion (Misc queries) | |||
Referencing Columns in a Row. PLEASE HELP!! | Excel Worksheet Functions |