SumProduct

[tony_813]

Plan A 479 79.02
Plan A 1222 77.86
Plan A 1083 77.89
Plan A 3 50
Plan A 635 69.13
Plan A 227 80.62
Plan B 411 77.62
Plan B 1233 78.67
Plan B 865 72.14
Plan B 1497 72.18
Plan B 161 78.57
Plan B 413 82.45
Plan B 1425 72.18
Plan B 1 0
Plan B 1073 78.38

Hello Everyone
Plans are in Column A, Number of Plans in column B, Avg in column C
By knowing the specific Range i would generally use a SumProduct and base it on
the range itself as in =SUMPRODUCT(B2:B16,C2:C16)/SUM(B2:B16) based on all plans being the same.. However... the data may change on the sheet the number of Plan As could be less.. so how can i get the same result as the sumproduct but take into account only a specific plan. i hope i made sense...

 

[T. Valko]

not sure what the -- means?

See this:

http://xldynamic.com/source/xld.SUMPRODUCT.html

 

[markmzz]

thank you for the explination ( :

Thanks for the feedback.

Markmzz