COUNTING CELLS GIVEN OTHER CELLS?

L

LIANA

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
 
B

Biff

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
 
Top