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!