Calculate weighted average based on conditions

  • Hi All,

    I would truly appreciate your help to solve a conditional SUMPRODUCT issue.

    I have four columns (A, B, C, D, & E). Column A, B, & C contain Text data. Column D contains Percentage data. And Column E contains Number data.

    Basically, I want to calculate the weighted average of column D & E if and only if conditional requirements for Column A AND Column B AND Column C are met. For instance, the condition for Column A would be if cell content is “Blue”, Column B if cell content is “Bag”, and Column C “10|11”.

    I had a look at the forum and tried a few times without success. I know how to calculate the weighted average of Column D & E using the SUMPRODUCT function but I have issue “inserting” the conditions.

    Thanks a lot in advance,


  • Re: Calculate weighted average based on conditions

    Hello Alex,

    Welcome to Ozgrid. We're glad to have you on board, however, please note the following regarding thread titles:

    Thread titles are used in searching the forum, therefore, it is vital they be written to accurately describe your [COLOR="blue"]thread content or overall objective[/COLOR] using ONLY search friendly key words. That is, your title use as search terms would return relevant results.

    • The title must not use non-essential words such as:"Help needed", "Formula problem", "Please help", "urgent", "Code issue", "Need Advice", etc. Such words dilute the title/search results.
    • The title should not contain VBA code or formula syntax or use abbreviations, jargon, delimiters (e.g. slashes, commas, colons, etc)
    • The title should not assume or anticipate a solution as in referencing Excel functions or VBA methods - the actual solution is often quite different

    Your title of "[COLOR="red"]Excel\Conditional SUMPRODUCT [/COLOR]" does not describe your thread or objective and is not helpful to those searching the forum for a solution to a similar need.

    [COLOR="darkred"]Please note the change to your title, which is based on the objective stated in your thread.[/COLOR]

    If the new title still does not accurately describe your thread you may make further edits as needed per the above guidelines.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!