Formula Help - Logic Dependent on Other Columns

  • Thread starter Thread starter Al Franz
  • Start date Start date
A

Al Franz

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.
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter Range Not Working, Removes Total Row?? 3
Help needed 0
VBA - Run same logic on values in columns 2 & 3 0
Mid column sum formulas with varied ranges to sum 17
Count the columns from one sheet and paste it in another sheet 0
Column number of last column that returns value ignore formulas 8
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Lookup formula needed 1

Back
Top