Complicated Formula Help

[rogercross]

Hi all,

In one cell I am trying to display a percentage based on a few things:


1) I have a dropdown box (in every row from B6:B35) with 8 different words I can choose from which represent either a 'true' or 'false' value which then displays in the column next to it (C6:C35)


2) I then have another 2 columns (D6:E35) that I enter information into


3) In these 2 columns I enter either a 'W' or an 'L'


4) The percentage i want to display is the total amount of "W's" in cells D6:E35 divided by the total amount of "W's" and "L's" entered in D6:E35 then times by 100 (to get the percentage)


5) However, I only want to calculate this if the adjoining row equals "TRUE" (in column C)


6) I dont want anything to be calculated if the row in column C equals "FALSE"



Basically: If column C = TRUE then i want all W's vs all W's & L's calculated as a percentage but no "W's" or "L's" counted/calculated at all if column C = FALSE


Using the attached sheet as an example (please see link)
https://www.dropbox.com/s/2x1kinuq7m...ample.JPG?dl=0


I want the percentage displayed in the merged cell: CDE/40 41 42
ONLY IF Column C = TRUE then I want the total amount of "W's" (from all cells D6:E35) displayed as a percentage against the total amount of "W's" & "L's" (from all cells D6:E35)

In this example - there are 2 rows with "TRUE" displayed (C6 & C8) and in those cells (D6:E35) there are 3 "W's" and 1 "L". Therefore that is 3 W's out of 4 W's & L's in total which should equal a percentage of 75.0%. The "W's" & "L's" in D7 & E7 shouldn't count as C7 = FALSE

Any help greatly appreciated,
Thankyou!

[FDibbins]

Hi Roger, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

[Richard Buttrey]

Hi and welcome to the forum. Unfortunately our post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)