Recent content by Maillme

hi Skip, thanks for your reply. The example doesn't work, because my columns are changing also, as per my 2nd example (I confused things by duplicating formulas on 1st post). Here is a screen capture of my excel, if it helps illustrate the point better...

Thanks Zelgar, Sorry - I think because I didn't copy the actual formulas for the 2nd and 3rd examples it is not clear. (although yes, I do want to drag the formula across, but I want the row to change that is referenced in the sheet called: All Here is the actual formulae, and highlighted...

Oh, and forget the rest of the formula, I copy/paste without actually taking from the excel itself (just this window here), as the references further on in the formula woudl change... but they aren't relevant for this example. Neil

Sorry, first reference to sheet name is wrong. I left "All" but this should be "Sheet2" (I replaced for examples / simplicity sake, Neil

Hi there, I have this formula: =IF(All!C1="Employees",SUMIF(D2:D25,1,$B$2:$B$25)/(SUMIF(D2:D25,1,$B$2:$B$25)+SUMIF(D2:D25,2,$B$2:$B$25)),SUMIF(D2:D25,1,$C$2:$C$25)/(SUMIF(D2:D25,1,$C$2:$C$25)+SUMIF(D2:D25,2,$C$2:$C$25))) I'd like to drag this accross columns in one sheet, but would like the...

worked great. My final formula looks like: =IF(Q3="Employees",SUMIF(B3:P3,"Yes",$B$18:$P$18)/(SUMIF(B3:P3,"Yes",$B$18:$P$18)+SUMIF(B3:P3,"No",$B$18:$P$18)),SUMIF(B3:P3,"Yes",$B$19:$P$19)/(SUMIF(B3:P3,"Yes",$B$19:$P$19)+SUMIF(B3:P3,"No",$B$19:$P$19))) This works out weighted % of Yes answers...

Don't think so. thanks, ill try that. Neil

hi All, So my end result was: =SUMIF(B4:P4,"Yes",B5:P5)/(SUMIF(B4:P4,"Yes",B5:P5)+SUMIF(B4:P4,"No",B5:P5)) This works great... but, to further help me, would it be possible to adapt this formula to perform based on the value of another cell. So, What I want to do is: If Cell Q4 = "Employees"...

KJV, That worked perfectly. thank you..... now, the next step of my problem (I thought I would build up to it so as it would be easier to explain) - I need to somehow exclude some answers from the total weighted average..... So, it's all about weighting an average based on Yes, No, N/A Where...

Hi All, thanks for your response, but I'm maybe not being very clear. Here I will try my best to illustrate: I have countries in my columns, e.g.: UK, NL, Spain, Italy Each country has a number of employees Each country also answers a question, e.g. do you have a health and safety policy So...

Hi there, I am struggling to come up with a formula to use within Excel 2010. I would like to work out a weighted average based on the content of another cell... so, to try and illustrate, see image below: I would like to know how to calculate: - the % of employees who said yes - the % of...

Hi PHV, thanks for you're reply. I see the function, but I am not quite sure how to build this into my query?

Hi there, Apologies for this relatively simple request - but i'm not quite sure how to do this. I have a field in my record: dob I'm looking to run a query that will tell me all the birthdays in the next 6 weeks from when i run the query - but i;ve no idea the syntax for this? any help you...

Hi there, I have a spreadsheet which has income and outgoing expenditure - fairly simple. Income has: - Amount (A Column) - Date (B Column) - Description (C Column) - Ringfenced (D Column) The D column is a choice between yes or no - i have a data validation list to get these choices from a...

hi lameid - i ended up importing all my tables which worked a treat. thanks for your valuable help, Neil