Formula Help - Logic Dependent on Other Columns
 

Been struggling getting this formula to work. Though I would create a
sample and see if anyone could help. Take a look at....

http://franz.org/formula.xls

Has to do with using column counts and putting the value in the proper
column dependent on the value of another column. Hard to explain, if you
want to help out, take a look.

Kindly appreciated.

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