Formula for calculating percentages in a table column?

[Mr. Snrub]

I have an Excel table that displays my stock portfolio through the years, like so:

Date	Stock	Share Pricw	Number of Shares	Value
11/26/2020	AAPL	$116.03	5	$580.15
11/26/2020	PINS	$67.42	4	$269.68
11/26/2020	ROKU	$278.06	2	$556.12
11/27/2020	AAPL	$116.59	5	$582.95
11/27/2020	PINS	$69.72	4	$278.88
11/27/2020	ROKU	$275.34	2	$550.68

I want to add a column called "Percentage" that will take the Value column and calculate what the percentage of that stock is for my entire portfolio for that date. So, for example, AAPL for 11/26/2020 would be $580.15 / ($580.15 + $269.68 + $556.12) = 41.26%. How do I do this?

 

[etaf]

try a SUMIF()
=SUMIF(A:A,A2,E:E)
That gives the TOTAL Value for the date
NOW
E2/SUMIF(A:A,A2,E:E)
Assuming the columns above start at column A

Book1
	A	B	C	D	E	F
1	date		Value		Total	Percent
2	1/1/20		1		111	1%
3	1/2/20		2		222	1%
4	1/3/20		3		333	1%
5	1/1/20		10		111	9%
6	1/2/20		20		222	9%
7	1/3/20		30		333	9%
8	1/1/20		100		111	90%
9	1/2/20		200		222	90%
10	1/3/20		300		333	90%
Sheet1

Cell Formulas
Range	Formula
E2:E10	E2	=SUMIF(A:A,A2,C:C)
F2:F10	F2	=C2/SUMIF(A:A,A2,C:C)