View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LIANA
 
Posts: n/a
Default 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