• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multi-conditional Weighted Average - same and separate columns

Alk

New Member
Hello,

I am new to this forum; this is my first post. Thank you a robust forum, allowing people to become awesome in Excel.

I am requesting help with a 2 part issue that I have searched extensively - without success; this forum has a formula for one condition, but not multiple conditions - especially when both variables are in the same column.
  1. Formula for weighed average (2 conditions) where both conditions are in the same column
  2. Formula for weighted average (2 conditions) where conditions are in different columns
Below is the formula I am [successfully] using for a single condition:

=SUMPRODUCT((D3:D850)*(B3:B850="Purchase"),C3:C850)/SUMIFS(C3:C850,B3:B850,"Purchase")

All my attempts (spaced over several hours/days) to build on the above formula have not yielded desired results (speaks to my knowledge of spreadsheets).

All help/guidance is greatly appreciated!
 

Alk

Your file has some challenges while try to open it ...
Check H-column for ... Your case ... in the same column.
Where is Your sample of that other case?
 

Attachments

  • Example.xlsx
    10.1 KB · Views: 4
My apologies: column H, in the file I uploaded earlier, was a "practice column" for data that I had deleted; hence, I should have deleted column H before uploading the file since it is causing a distraction. The issues I am requesting help with are as mentioned above and those attempts are reflected in column J in the attached file.

I have deleted formulas in column H and have uploaded the revised file.

Note: I have put many hours in attempting to find the correct formulas, resulting in the creation of many "versions" of data - essentially all of which I have deleted.

Your support is greatly appreciated!
 

Attachments

  • Example.xlsx
    7.6 KB · Views: 3

Alk

You sent Your the 1st file again ... why?
... You skipped to show Your other cases.
You could move my used H-column anywhere which is free.
... I could guess something more, but it's You - who should able to give more ideas - what / how do You expect to get something?
 
1. I can see that one condition is Transaction Type being "Purchase" but I can't determine the 2nd condition; what is it?
2. What version of Excel are you using?
 
1. I can see that one condition is Transaction Type being "Purchase" but I can't determine the 2nd condition; what is it?
2. What version of Excel are you using?
Thank you for your polite, intelligent response. I figured out the formulas.
 
Back
Top