FunctionNameIf() 1 Condition only
FunctionNameIfs() Multiple Conditions
Data 1 Data 2 Data 3 Data 4
3900 2456 15941 84694
45697 3900 46497 87990
13971 34465 2642 68095 3900
10701 69706 Avi 71296 a
85484 16331 56140 44293
78850 6631 94932 3210 Dta
17236 53937 23899 4659
82039 91060 55554 51717
3900 45768 62533 3900
3900
Countifs Sumifs Averageifs MinIfs Maxifs
6 240619 40103.166667 23899 46497
Condition/Criteria Count CountA CountBlank
"Symbol+Value" 37 45 10
=
<
> Countif Countif Countif
<= 15 6 6
>=
<>
text Countif Sumif Averageif
15 1094027 72935.13333
Emp_Code Name Department Date Hired
A001 Rob Verhoff Sales 7/11/2000
A002 Shadow Elizabeth Operation 12/1/2000
A003 Ian Jenkins Finance 4/22/2001
A004 Shila Rani Operation 5/31/2001
A005 Ruben Torres Management 8/14/2002
A006 Marco Mehta IT 2/11/2003
A007 Mohit Dhinghra Operation 2/22/2004
A008 Tom Brown Production 3/8/2004
A009 Janet Alvarez Finance 4/19/2004
A010 Lauren Walker Production 6/25/2004
A011 Gurmeet Singh Marketing 7/17/2004
A012 Vinod Adwani Production 10/31/2004
A013 Jon Yang Marketing 3/6/2005
A014 Sydney Bennett Sales 11/22/2005
A015 Julio Ruiz Finance 5/29/2006
A016 Rajesh Kumar IT 9/8/2006
A017 Md. Naveed Ahmed Production 12/24/2006
A018 Krishna Dev Sales 2/9/2007
A019 Km. Ranjita Sales 4/30/2007
A020 Ravinder Pawar Production 12/8/2007
A021 Mohan Singh Marketing 1/3/2008
A022 Chloe Young Sales 8/22/2008
A023 Kishore Kumar Lalit Management 1/29/2009
A024 Jacquelyn Suarez IT 2/4/2009
A025 Rajan Kishore Management 2/14/2010
A026 Elizabeth Johnson Finance 12/19/2010
A027 Smith Jane Production 3/16/2011
A028 Shannon Carlson Marketing 8/21/2011
A029 Christy Zhu IT 11/21/2012
A030 Eugene Huang Production 3/31/2013
A031 Rajiv Kalra Marketing 5/21/2013
A032 Sharvana Jain Sales 6/7/2013
A033 Curtis Lu Finance 7/8/2013
A034 Rajkumar Verma Management 5/9/2014
A035 Rajkishor Gupta Management 2/11/2015
A036 Chinmay Singh Finance 9/1/2015
A037 Potter Betty Operation 9/14/2015
A038 Sonu Baweja Finance 9/20/2015
A039 Doe John Management 8/27/2016
A040 Vibhore Sharma Sales 12/16/2016
Location Country Gender Joining Year Office Type
Victoria Australia Female 2000 Nodal Branch
Tasmania Australia Female 2000 Nodal Branch
Oregon United States Female 2001 Nodal Branch
Kolkata India Female 2001 Head Office
Tasmania Australia Female 2002 Zonal
Victoria Female 2003 Zonal
Delhi India Male 2004 Head Office
California United States Male 2004 Nodal Branch
New South Wales Australia Female 2000 Head Office
Washington Female 2000 Head Office
Delhi Male 2004 Nodal Branch
Kolkata India Male 2004 Head Office
Queensland Australia Female 2005 Nodal Branch
Washington United States Female 2005 Head Office
Queensland Female 2006 Nodal Branch
Delhi India Male 2006 Head Office
Kolkata India Male 2006 Zonal
Kolkata India Male 2007 Head Office
Mumbai Female 2007 Nodal Branch
Mumbai India Male 2007 Head Office
Delhi India Male 2008 Head Office
California Female 2008 Zonal
Delhi India Male 2009 Zonal
Queensland Female 2009 Zonal
Mumbai India Male 2010 Head Office
New South Wales Australia Female 2010 Nodal Branch
British Columbia Male 2011 Zonal
Queensland Female 2011 Head Office
New South Wales Australia Female 2012 Head Office
Victoria Australia Female 2013 Head Office
Delhi India Male 2013 Head Office
Mumbai India Male 2013 Zonal
Queensland Australia Female 2013 Head Office
Kolkata India Male 2014 Head Office
Kolkata India Male 2015 Head Office
Delhi India Male 2015 Head Office
British Columbia Canada Male 2015 Head Office
Delhi India Male 2015 Head Office
Washington United States Male 2016 Nodal Branch
Delhi India Male 2016 Head Office
Monthly Sal Annual Sal
₹ 33,324.00 ₹ 399,888.00
₹ 23,694.00 ₹ 284,328.00
₹ 47,546.00 ₹ 570,552.00
₹ 18,114.00 ₹ 217,368.00
₹ 57,487.00 ₹ 689,844.00
₹ 61,355.00 ₹ 736,260.00
₹ 19,399.00 ₹ 232,788.00 United States
₹ 19,841.00 ₹ 238,092.00
₹ 47,778.00 ₹ 573,336.00
₹ 21,602.00 ₹ 259,224.00 Country
₹ 54,542.00 ₹ 654,504.00 Australia
₹ 19,549.00 ₹ 234,588.00
₹ 58,821.00 ₹ 705,852.00 Department
₹ 56,762.00 ₹ 681,144.00 Marketing
₹ 58,575.00 ₹ 702,900.00
₹ 41,834.00 ₹ 502,008.00
₹ 21,970.00 ₹ 263,640.00
₹ 51,939.00 ₹ 623,268.00
₹ 51,030.00 ₹ 612,360.00
₹ 19,429.00 ₹ 233,148.00
₹ 37,815.00 ₹ 453,780.00
₹ 32,912.00 ₹ 394,944.00
₹ 74,422.00 ₹ 893,064.00
₹ 58,694.00 ₹ 704,328.00
₹ 87,889.00 ₹ 1,054,668.00
₹ 58,136.00 ₹ 697,632.00
₹ 21,265.00 ₹ 255,180.00
₹ 59,751.00 ₹ 717,012.00
₹ 39,823.00 ₹ 477,876.00
₹ 18,786.00 ₹ 225,432.00
₹ 53,621.00 ₹ 643,452.00
₹ 52,025.00 ₹ 624,300.00
₹ 55,708.00 ₹ 668,496.00
₹ 75,883.00 ₹ 910,596.00
₹ 63,548.00 ₹ 762,576.00
₹ 44,559.00 ₹ 534,708.00
₹ 17,212.00 ₹ 206,544.00
₹ 57,994.00 ₹ 695,928.00
₹ 62,120.00 ₹ 745,440.00
₹ 54,778.00 ₹ 657,336.00
Employee count From Australia
9
Australia's Annual Sal
4722684
Annual Sal Total for United States
2235228
Annual Sal Total for the Country Australia and the Department for Marketing
705852
Employee Working in United States
Average Annual Salary in United States
4 558807
Marketing
