Conditional Weighted Average Formula in Excel

[@spartren]

Thank you sir! I have used this video several times since it's original posting.

[@edferrri]

I finished my project thanks to you, very clear thanks!

[@danyo6938]

I was stuck trying to calculate a weighted average on two data arrays for dates in the last 30 days. Your video helped a ton! Mahalo!

[@johnsoncj2002]

Fantastic formula. Exactly what I was looking for. Thank you!!

[@LonestarPaul]

FANTASTIC! Thank you so much for posting this. Subscribed. Thanks!

[@maximumaverage]

You are the goat. Thanks dude saved me a lot of erroneous calculations in my model!

[@gommarbun9726]

this video save my day

[@OmarFloc1]

Hi! Amazing video! You helped me a lot! Do yo know if it’s possible to put more than 1 conditional? How can I do it?

[@sachinnewa5449]

Exactly what I am looking for. Thank you so much for this fantastic video.

[@jonpetix6385]

Dude this video helped me a lot. Many thanks.

[@alexsanderjusto7741]

Muito obrigado! procurei em muitos lugares e em nenhum consegui resolver, mas o seu video me ajudou! sou do Brasil, MUITO OBRIGADO!!!

[@ingalepn]

Spencer, A very helpful formula trick. Syntax you used: Sumproduct(--(ConditionRange=ConditionValue), Array1, Array2)/Sumif(Array2,Criteria, SumRange). I was wondering if this two dashes - - (ConditionRange=ConditionValue) works on any formula that you know off?

[@mdmantejsingh]

Thank you so much, very helpful. I was dividing by SUM. instead of SUMIF. Thankyou!!!

[@lolwtf46]

This was great!! Exactly what I was looking for

[@rahulkanjani7792]

YOU ARE A LIFESAVER Thank you Sir Stay Safe

[@SirLancelott]

Hi Spencer, this video was incredible! I wanted to ask as well… if you wanted to do this in between dates, how would you incorporate dates into this formula please?

[@Rkucins]

this is useful SO much! Thanks for this tutorial.Need to share it for sure

[@geopacha6413]

the best, thank you, gracias mi hermano me salvaste

[@adventuresincre]

A la orden

[@Vidsandso]

Excelent video! saved me a headache :)

[@kenoommen7002]

hi , what if I have multiple criterias apart from tenant type , say for example , the floor which the tenant is one? Can I use the same formula? I figure I can use sumifs for the divisor, but can will the numerator change accordingly?

[@akuakanwa7868]

Hi Spencer, thank you so much for this. I have a quick question. can i possibly use two conditions in one formula assuming some rents are $0 and i would like to calculate the weighted average rent by tenant type. Thanks this is very helpful

[@asutoshpatel4436]

Yeah you can. Follow this: Sumproduct ( - - (conditionrange = condition value), - - (condition range > 0), array1, array2,...)

[@dineshhotchandani2033]

its not working @@asutoshpatel4436

[@asutoshpatel4436]

@@dineshhotchandani2033 Hmm that's odd. Can you screenshot what you're inputting in the field? And what your goal is?

[@dineshhotchandani2033]

@@asutoshpatel4436 now it's working... I missed the coma(,) between two conditions... thanks a lot...it really helped me...

[@asutoshpatel4436]

@@dineshhotchandani2033 ofc anytime! Knowledge should be free to all those who wanna learn :)

[@renewablefuelsanalyst8263]

how do you implement 2 conditions? I want a weighted average based on year and month from my data sheet?

[@adventuresincre]

Sure. We added this in the blog post (www.adventuresincre.com/conditional-weighted-average-sumproduct-sumif/) where we share the file. But the formula for two conditions is: = SUMPRODUCT(((ConditionArray1 = “Condition1”) * (ConditionArray2 = “Condition2”)), Array1, Array2) / SUMIFS(Array1, ConditionArray1, “Condition1”, ConditionArray2, “Condition2”)

[@divyasoman1203]

Thank you, very useful.

[@mohamedkl3901]

very useful thank you so much

[@tannerhenson6744]

Thank you!