Average just of the minus

[poikl]

Hi, Can you please help me with formula to just show the average LOSS and separately the average GAINS in a column C which posts both, gains and losses?

ColA ColB ColC

10/20/2024	161.8882	1.54322
10/22/2024	157.9199	-3.96828
10/27/2024	162.7701	4.85012
10/31/2024	159.2427	-3.52736
11/3/2024	160.345	1.1023
11/7/2024	157.9199	-2.42506
11/10/2024	158.5813	0.66138
11/14/2024	157.9199	-0.66138
11/17/2024	158.5813	0.66138
11/21/2024	157.6995	-0.88184

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Following from the above, if you have the AVERAGEIFS function ..

24 11 22.xlsm
	C	D	E	F
1			Av Gain	Av Loss
2	1.54322		1.76368	-2.292784
3	-3.96828
4	4.85012
5	-3.52736
6	1.1023
7	-2.42506
8	0.66138
9	-0.66138
10	0.66138
11	-0.88184
AVERAGEIFS

Cell Formulas
Range	Formula
E2	E2	=AVERAGEIFS(C2:C11,C2:C11,">0")
F2	F2	=AVERAGEIFS(C2:C11,C2:C11,"<0")