Get sum of above rows based on condition

[nectarynes]

I am trying to get dynamically the sum of Column E values if the corresponding F row value is empty.
Any ideas what formula I should have on column G?
Here is the live document link:

OneDrive

Sign in to your OneDrive cloud storage and Office Online.

1drv.ms

 

[rohitsaraf15]

use the following formula:

I am trying to get dynamically the sum of Column E values if the corresponding F row value is empty.
Any ideas what formula I should have on column G?
Here is the live document link:

OneDrive

Sign in to your OneDrive cloud storage and Office Online.

1drv.ms

View attachment 94149

sumif($f:$f,"",$e:$e)

 

[DanteAmor]

Hi @nectarynes
Welcome to the MrExcel forum. Please accept my warmest greetings and sincere hope that all is well.

Try the following formula in cell G2 and copy it down.

Dante Amor
	A	B	C	D	E	F	G
1	Location	Date	Game	Stakes	Amount	Cashout	Profit/Loss
2	New York	08/06/2023	PLO5	05-oct	1,500	2,720	1,220
3	New York	09/06/2023	PLO5	05-oct	3,000
4					500
5					200	5,000	1,300
6	COD	22/06/2023	NLH	05-may	500
7					500
8					1,200
9					2,000
10					3,000	1,000	-6,200
11	test	23-jun			2000	300	-1,700
12					100
13					200
14					300
15					400
16					500
17					600
18	test2	23-jun			700	5000	2,200
Hoja1

Cell Formulas
Range	Formula
G2:G18	G2	=IF(F2="","",F2-(SUM($E$1:E2))+SUMIF($F$1:F1,"<>")-SUMIF($G$1:G1,"<>"))

--------------
Let me know the result and I'll get back to you as soon as I can.
Cordially
Dante Amor
--------------​

 

[nectarynes]

Hi @nectarynes
Welcome to the MrExcel forum. Please accept my warmest greetings and sincere hope that all is well.

Try the following formula in cell G2 and copy it down.

Dante Amor
	A	B	C	D	E	F	G
1	Location	Date	Game	Stakes	Amount	Cashout	Profit/Loss
2	New York	08/06/2023	PLO5	05-oct	1,500	2,720	1,220
3	New York	09/06/2023	PLO5	05-oct	3,000
4					500
5					200	5,000	1,300
6	COD	22/06/2023	NLH	05-may	500
7					500
8					1,200
9					2,000
10					3,000	1,000	-6,200
11	test	23-jun			2000	300	-1,700
12					100
13					200
14					300
15					400
16					500
17					600
18	test2	23-jun			700	5000	2,200
Hoja1

Cell Formulas
Range	Formula
G2:G18	G2	=IF(F2="","",F2-(SUM($E$1:E2))+SUMIF($F$1:F1,"<>")-SUMIF($G$1:G1,"<>"))

--------------
Let me know the result and I'll get back to you as soon as I can.
Cordially
Dante Amor
--------------​

Wow, you guys rock! What a forum!

 

[DanteAmor]

Im glad to help you. Thanks for the feedback.