Thread: Referencing a range of columns and rows with the IF function
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default Referencing a range of columns and rows with the IF function

Not quite sure what you're saying. Do you want the formula to return a 1
only when there is only a single 1 in the range?

If so

=IF(COUNTIF(A1:AS3,1)=1,1,"")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=528879

Reply With QuoteReply With Quote