Calculating weighted average excluding blank cells

[mflatt23]

Hi everyone,

I have a question that I've been trying to figure out and hoping the community might have some tips. For my individual stock portfolio, I'm trying to calculate a weighted average in cell D21 that excludes cell C6 and D6 from the weighted average calculation (SOFI). How can I do this using the SUMPRODUCT formula in the screenshot below? Or is there another equation that fits better in this situation? I've tried searching online, but haven't found anything that works exactly as I need.

Thank so much!

 

[shift-del]

Hi

Mappe8
	A	B	C
2		2,2%	22,0%
3		2,2%	-1,0%
4		0,8%	36,0%
5	SOFI	0,9%	9,0%
6		1,4%	32,0%
7		2,0%	13,0%
8		1,2%	6,0%
9		1,0%	33,0%
10		2,2%	26,0%
11		1,6%	41,0%
12		1,2%	40,0%
13		1,1%	-2,0%
14
15			20,982%
Tabelle1

Cell Formulas
Range	Formula
C15	C15	=SUMPRODUCT(B2:B13,C2:C13,--(A2:A13<>"SOFI"))/SUMIFS(B2:B13,A2:A13,"<>SOFI")

 

[mflatt23]

Ah! Forgot to include that column with the names. Thank you!