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.
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!
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.
- Formula for weighed average (2 conditions) where both conditions are in the same column
- Formula for weighted average (2 conditions) where conditions are in different columns
=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!