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

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