Hi folks,

Hope you can help with an excel formula I'm trying to set up in Excel 2010 without much success. I've attached a sample but basically I need to calculate in one single formula a kind of weighted average % figure. I have one column with a weighting factor from 0 to 1 (cells D3:D9 in the attached), I have another column with a % figure (cells C3:C9 in the attached) and I have another column with a name value which (cells B3:B9 - this is called "example" in the attached). I have to have one cell with the total "weighted" average of these percentages also factoring in the name value condition.

In the attached the yellow highlighted cell C12 contains the value I need as an output and how I have calculated it, the blue highlighted cell G5 shows my so far abortive attempts at replicating that output. I've tried various combinations of sumproduct / array formuls / sumifs / averageifs without much success. Any help would be great!