Scribd
Upload
10 views9 pages

Count Functions

Uploaded by

Shivani Gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
10 views9 pages

Count Functions

Uploaded by

Shivani Gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 9

LOOKUPASHEESH.

IN

✘ COUNT Function ✘ COUNTA Function


Example Result Example Result
lookupashee3 lookupashee4
21 21 4

67 67
31 31

This function counts the number of This function counts the non-
cells that cotain numbers blank cells
Argument: COUNT(value1, Argument:
[value2],..) COUNTA(value1,
[value2],...)
Lower
✘ COUNTBLANK Function Upper
Example Result Proper
Equip yourself with
lookupashee1 more advance tips and
21 1 techniques
@LOOKUPASHEESH.IN
67
31

This function counts that


number of cells that are blank
within a specified range
Argument:
COUNTBLANK(range)
Student Name Gender Age Maths English Hindi Physics Electronics

Vimal Rai Male 30 Yes Yes


Male 27 Yes Yes Yes
John Smith Male 29 Yes
David Alex Male 25 Yes Yes Yes
Sapna Arora 24 Yes
Sachin Seth Male 21
Rachel Ross Female 27 Yes Yes Yes
Kevin Graham 21 Yes Yes
Anand Sharma 25 Yes Yes Yes
Sweety Chander Female 28 Yes Yes Yes Yes
Rahul Upadhyay Male Yes Yes Yes Yes Yes
Asheesh Mattoo 26 Yes
Anukriti Sharma Female 28 Yes Yes
Priyanka Chatterjee Female 23 Yes Yes Yes

1) How many students have not mentioned their gender 4


2) How many students have their age missing 1
3) How many students have mentioned their age 13
4) Write a formula in column "N" to check how many subects are taken by each student.
Total Subjects
Chemistry Botony Economics Accounting History Taken
Yes Yes Yes Yes 6
Yes Yes Yes 6
Yes Yes Yes 4
Yes 4
Yes Yes Yes Yes 5
Yes 1
Yes Yes 5
Yes Yes Yes 5
Yes Yes Yes 6
Yes 6
Yes Yes Yes 8
Yes Yes 3
Yes Yes 4
Yes 4
LOOKUPASHEESH.IN
✘ COUNTIF Function
This function counts the number of Date Name
cells that meet a specfic criteria 11-Apr-14 Vimal Rai
within the range specified. This
17-Apr-14 Karthik S
function is limited to one range and
one criteria 6-May-14 John Smith
Argument: 14-May-14 David Alex
COUNTIF(range,criteria) 8-May-14 Sapna Arora
31-May-14 Sachin Seth
1-Jun-14 Rachel Ross
13-Jun-14 Kevin Graham
21-Jun-14 Anand Sharma
27-Jun-14 Sweety Chander
Equip yourself with 10-Jul-14 Rahul Upadhyay
more advance tips and 23-Jul-14 Asheesh Mattoo
techniques 30-Jul-14 Anukriti Sharma
@LOOKUPASHEESH.IN 4-Aug-14 Priyanka Chatterjee
9-Aug-14 Kiran Gupta
Gender Age Sales Remarks Criteria
Male 30 Yes Total Sales Yes
Male 27 Yes Gender Diversity Female
Male 29 Yes Age greater than 25
Male 25 No Contacts on or after 8-May-14
Female 24 No Name Starting with Letter S
Male 21 na Name containing Letter h
Female 27 No
Male 21 Yes
Male 25 Yes
Female 28 Yes
Male 25 Yes
Male 26 na
Female 28 No 8
Female 23 No 2
Female 25 Yes
COUNTIF TRUE

Formula
10 10 8 10
6 6 6
7 7 7
12 12 12 >= .=>
3 3 3
11 11 11

8 8
8

8 2 5
2
Date Name Gender Age Subject Hobbies
11-Apr-14 Vimal Rai Male 30 hindi Gardening
17-Apr-14 Karthik S Male 27 english Shopping 7
6-May-14 John Smith Male 29 hindi cooking 8
14-May-14 David Alex Unknown 25 hindi Gardening 3
27-May-14 Sapna Arora Female 24 english Shopping
31-May-14 Sachin Seth Male 21 science cooking
1-Jun-14 Rachel Ross Female 27 hindi Gardening
13-Jun-14 Kevin Graham Male 21 hindi Shopping
21-Jun-14Anand Sharma Male 25 science cooking
27-Jun-14Sweety ChanderUnknown 28 hindi Gardening
10-Jul-14Rahul Upadhyay Male 25 maths Shopping
23-Jul-14Asheesh Mattoo Male 26 science cooking
30-Jul-14Anukriti SharmaFemale 28 science Gardening
4-Aug-14
Priyanka Chatterjee
Unknown 23 english Gardening
9-Aug-14 Kiran Gupta Female 25 hindi cooking

hindi
english

excelxor.com
hindi english Consolidated Formulae
gardening 4 1
hindi english cooking 2 0 7
gardening cooking
4 0

4 0

query if I want three criteria with


male male
gardening Shopping male
1 1
0 1

You might also like