Scribd
Upload
60 views11 pages

Using COUNTIFS Function

The document demonstrates how to use Excel's COUNTIFS function to count cells that meet single or multiple criteria across a dataset of student exam scores. It shows COUNTIFS being used to count students who scored above 80 in Physics, students who scored above 80 in both Physics and Chemistry, and students within different grade criteria. Finally, it applies COUNTIFS in a range to count student ranks in Chemistry.

Uploaded by

acoustica2022
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
60 views11 pages

Using COUNTIFS Function

The document demonstrates how to use Excel's COUNTIFS function to count cells that meet single or multiple criteria across a dataset of student exam scores. It shows COUNTIFS being used to count students who scored above 80 in Physics, students who scored above 80 in both Physics and Chemistry, and students within different grade criteria. Finally, it applies COUNTIFS in a range to count student ranks in Chemistry.

Uploaded by

acoustica2022
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

Using COUNTIFS Function to Count Cells with Single Criteria

Examination Record Students with At Least


Student Name
Physics Chemistry 80 in Physics
Ricky Hopkings 75 79 6
Stuart Johnson 82 80
Natalia Austin 54 88
Ricardo Benjamin 98 79
Alisha Moor 83 81
Anjela Morris 39 39
Murcus North 99 79
Shaun Broad 74 80
Alfred Moyes 69 68
Gregory Simpson 42 40
Richard Hick 37 39
Steven Smith 89 93
Peter Boon 79 80
Kevin Orwell 80 80
George Embappe 79 78
Christina Georgina 39 39

Practice Yourself

Examination Record Students with At Least


Student Name
Physics Chemistry 80 in Physics
Ricky Hopkings 75 79
Stuart Johnson 82 80
Natalia Austin 54 88
Ricardo Benjamin 98 79
Alisha Moor 83 81
Anjela Morris 39 39
Murcus North 99 79
Shaun Broad 74 80
Alfred Moyes 69 68
Gregory Simpson 42 40
Richard Hick 37 39
Steven Smith 89 93
Peter Boon 79 80
Kevin Orwell 80 80
George Embappe 79 78
Christina Georgina 39 39
Inserting COUNTIFS Function to Count Cells with Multiple Criteria

Examination Record Students with At Least 80


Student Name
Physics Chemistry in Physics and Chemistry
Ricky Hopkings 75 79 4
Stuart Johnson 82 80
Natalia Austin 54 88
Ricardo Benjamin 98 79
Alisha Moor 83 81
Anjela Morris 39 39
Murcus North 99 79
Shaun Broad 74 80
Alfred Moyes 69 68
Gregory Simpson 42 40
Richard Hick 37 39
Steven Smith 89 93
Peter Boon 79 80
Kevin Orwell 80 80
George Embappe 79 78
Christina Georgina 39 39

Practice Yourself

Examination Record Students with At Least 80


Student Name
Physics Chemistry in Physics and Chemistry
Ricky Hopkings 75 79
Stuart Johnson 82 80
Natalia Austin 54 88
Ricardo Benjamin 98 79
Alisha Moor 83 81
Anjela Morris 39 39
Murcus North 99 79
Shaun Broad 74 80
Alfred Moyes 69 68
Gregory Simpson 42 40
Richard Hick 37 39
Steven Smith 89 93
Peter Boon 79 80
Kevin Orwell 80 80
George Embappe 79 78
Christina Georgina 39 39
Multiple Criteria

tudents with At Least 80


n Physics and Chemistry
4

tudents with At Least 80


n Physics and Chemistry
Using COUNTIFS Array Formula for Counting Grades

Examination Record Grades in Physics


Student Name
Physics Chemistry Grade Criteria
Ricky Hopkings 75 79 A+ >=80 <100
Stuart Johnson 82 80 A >=70 <80
Natalia Austin 54 88 A- >=60 <70
Ricardo Benjamin 98 79 B >=50 <60
Alisha Moor 83 81 C >=40 <50
Anjela Morris 39 39 F >=00 <40
Murcus North 99 79
Shaun Broad 74 80
Alfred Moyes 69 68
Gregory Simpson 42 40
Richard Hick 37 39
Steven Smith 89 93
Peter Boon 79 80
Kevin Orwell 80 80
George Embappe 79 78
Christina Georgina 39 39

Practice Yourself

Examination Record Grades in Physics


Student Name
Physics Chemistry Grade Criteria
Ricky Hopkings 75 79 A+ >=80 <100
Stuart Johnson 82 80 A >=70 <80
Natalia Austin 54 88 A- >=60 <70
Ricardo Benjamin 98 79 B >=50 <60
Alisha Moor 83 81 C >=40 <50
Anjela Morris 39 39 F >=00 <40
Murcus North 99 79
Shaun Broad 74 80
Alfred Moyes 69 68
Gregory Simpson 42 40
Richard Hick 37 39
Steven Smith 89 93
Peter Boon 79 80
Kevin Orwell 80 80
George Embappe 79 78
Christina Georgina 39 39
des

es in Physics
Students
6
4
1
1
1
3

es in Physics
Students
Applying Excel COUNTIFS Function in Range for Counting Ranks

Examination Record Ranks in


Student Name
Physics Chemistry Chemistry
Ricky Hopkings 75 79 10
Stuart Johnson 82 80 7
Natalia Austin 54 88 2
Ricardo Benjamin 98 79 10
Alisha Moor 83 81 3
Anjela Morris 39 39 16
Murcus North 99 79 10
Shaun Broad 74 80 7
Alfred Moyes 69 68 12
Gregory Simpson 42 40 13
Richard Hick 37 39 16
Steven Smith 89 93 1
Peter Boon 79 80 7
Kevin Orwell 80 80 7
George Embappe 79 78 11
Christina Georgina 39 39 16

Practice Yourself

Examination Record Ranks in


Student Name
Physics Chemistry Chemistry
Ricky Hopkings 75 79
Stuart Johnson 82 80
Natalia Austin 54 88
Ricardo Benjamin 98 79
Alisha Moor 83 81
Anjela Morris 39 39
Murcus North 99 79
Shaun Broad 74 80
Alfred Moyes 69 68
Gregory Simpson 42 40
Richard Hick 37 39
Steven Smith 89 93
Peter Boon 79 80
Kevin Orwell 80 80
George Embappe 79 78
Christina Georgina 39 39
Overview of Data Set

Examination Record
Student Name
Physics Chemistry
Ricky Hopkings 75 79
Stuart Johnson 82 80
Natalia Austin 54 88
Ricardo Benjamin 98 79
Alisha Moor 83 81
Anjela Morris 39 39
Murcus North 99 79
Shaun Broad 74 80
Alfred Moyes 69 68
Gregory Simpson 42 40
Richard Hick 37 39
Steven Smith 89 93
Peter Boon 79 80
Kevin Orwell 80 80
George Embappe 79 78
Christina Georgina 39 39

You might also like