Finding variance with applying condition.

[Samiur Rahman]

I want to find the variance of salaries by applying conditions with an age limit < 35.
I tried with VARPA function , used this formula: =VARPA(IF(age1:ageXX < 35, salary1:salaryXX))
But it is providing me a result of 0.
can anyone please show me my fault in this case?

 

[Skybluekid]

Try this

Book1
	A	B	C	D	E	F	G	H	I
5	Name	Age	Gender	Country	Ethnicity	Start Date	Departmet	Position	Salary
6	WilsonK	34	Male	United States	White	7/5/2011	Production	Production Technician	$ 41,600.00
7	Trina	29	Female	United States	White	1/7/2008	Production	Production Technician	$ 43,680.00
8	Sam	34	Male	United States	White	9/30/2013	Production	Production Technician 1	$ 45,760.00
9	Alejandro	30	Male	United States	White	1/5/2015	WIS	Network Engineer	$ 93,600.00
10	Francesco A	34	Male	United States	Two or more races	2/20/2012	Production	Production Technician 1	$ 34,860.00
11	Helen	28	Female	United States	White	7/7/2014	Production	Production Technician 1	$ 33,280.00
12	Dianna	27	Female	United States	White	4/4/2011	Production	Production Technician 11	$ 56,160.00
13	Bonalyn	30	Female	United States	Asan	2/16/2015	Admin Offices	Sr. Accountant	$ 72,696.00
14	Elsa	34	Female	United States	Black or African American	1/5/2009	Production	Director of Operations	$124,800.00
15	Mia	32	Female	United States	Black or African American	10/27/2008	Admin Offices	Accountant	$ 59,280.00
16	. In•enh	24	Male	United States	White	9/29/21714	Prnd,cti,-,n	Prnrf' '"tinn Technician 11	$ 45,760.00
17
18									Variance
19									$ 91,520.00
Sheet7

Cell Formulas
Range	Formula
I19	I19	=MAXIFS(I6:I16,B6:B16,"<"&35)-MINIFS(I6:I16,B6:B16,"<"&35)