View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Malcolm Gordon
 
Posts: n/a
Default COUNTIF function query for multiple colums

How do I count the number of occurrences of "1" in the A column each time
there is a negative value in the J column on the same row.

i.e. if cell A1 has a value of 1 and cell J1 has a value of -5 I want this
cell to be counted.