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

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" <LIANA@discussions.microsoft.com> wrote in message
news:5C84CE4F-3C37-4049-B10B-0C0A7C77192B@microsoft.com...
> 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