View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cliff
 
Posts: n/a
Default Help with formula

A4=IF(COUNTIF(A1:AS1,1)=2,1,"")

The above formula searches a range of cells looking for the number 1
occurring 2 times and either returning 1 or leaving the cell blank.

How could the formula be changed to only do the search if cell A1 was equal
to the number 1?