Thread: Formula Help - Logic Dependent on Other Columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron Coderre[_5_] Ron Coderre[_5_] is offline
external usenet poster
  
Posts: 91
Default Formula Help - Logic Dependent on Other Columns
Try putting this formula in G2:
=IF($F2=G$1,$E2/COUNTIF($B2:$D2,"X"),"")

Then copy it throughout the yellow range (G2:J10)

Does that do what you want?
--
Regards,
Ron

Reply With QuoteReply With Quote