Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTING CELLS GIVEN OTHER CELLS?
HOW WOULD COUNT THE CELLS IN COLUMN A, GIVEN WHAT LAYS BESIDE IT IN COLUMN B?
FOR EXAMPLE, ONLY COUNT THE CELLS CONTAINING "1" IN A, GIVEN THE CELL NEXT TO IT IN B CONTAINS A "2" I HAVE SPENT AN ENTIRE DAY ON THIS AND CAN'T SEEM TO FIGURE IT OUT? LIANA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTING CELLS GIVEN OTHER CELLS?
Hi!
Please turn off your caps lock! Try this: =SUMPRODUCT(--(A1:A100=1),--(B1:B100=2)) Or, if the values really are text: =SUMPRODUCT(--(A1:A100="1"),--(B1:B100="2")) Biff "LIANA" wrote in message ... HOW WOULD COUNT THE CELLS IN COLUMN A, GIVEN WHAT LAYS BESIDE IT IN COLUMN B? FOR EXAMPLE, ONLY COUNT THE CELLS CONTAINING "1" IN A, GIVEN THE CELL NEXT TO IT IN B CONTAINS A "2" I HAVE SPENT AN ENTIRE DAY ON THIS AND CAN'T SEEM TO FIGURE IT OUT? LIANA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Cells | Excel Discussion (Misc queries) | |||
Counting shaded cells | Excel Worksheet Functions | |||
Counting filled cells in excel | Excel Worksheet Functions | |||
Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel |