Questions and Answers
What is the purpose of the COUNTIFS function in Excel?
To count cells that meet multiple criteria
In the provided Excel formula, =SUM(A1:A2), what does it calculate?
The sum of all values in cells A1 and A2
How can you calculate the total Cash Reward earned in the Math subject using Excel functions?
=SUMIF(RANGE1, "Math", RANGE2)
What is the purpose of the VLOOKUP function in Excel?
Signup and view all the answers
In Excel, what does the formula =COUNTIF(C2:C10, "> NAME SUBJECT GRADE REWARD") do?
Signup and view all the answers
What is the difference between COUNTIF and COUNTIFS functions in Excel?
Signup and view all the answers
Which Excel function would you use to sum up all the rewards greater than $500?
Signup and view all the answers
What would be the result of applying the VLOOKUP function to 'Kristine' in the provided data?
Signup and view all the answers
In Excel, what does the formula =COUNTIFS(B:B, "English", C:C, "Math 90 100") do?
Signup and view all the answers
When using =SUM(D2:D4) in Excel to calculate Kristine's total Cash Reward, what would it result in?
Signup and view all the answers
Study Notes
COUNT Formula
 The COUNT formula is used to count the number of cells in a range that contain numbers.
 The syntax for the COUNT formula is
=COUNT(range)
.  Example:
=COUNT(C2:C4)
counts the number of cells in the range C2:C4 that contain numbers.
COUNTIF Formula
 The COUNTIF formula is used to count the number of cells in a range that meet a specified condition.
 The syntax for the COUNTIF formula is
=COUNTIF(range, criteria)
.  Examples:

=COUNTIF(C2:C4, ">95")
counts the number of cells in the range C2:C4 that are greater than 95. 
=COUNTIF(A1:A2, "CRITERIA1")
counts the number of cells in the range A1:A2 that meet the criteria "CRITERIA1".

COUNTIFS Formula
 The COUNTIFS formula is used to count the number of cells in a range that meet multiple specified conditions.
 The syntax for the COUNTIFS formula is
=COUNTIFS(range1, criteria1, range2, criteria2)
.  Examples:

=COUNTIFS(B2:B10, "Math", C2:C10, ">95")
counts the number of cells in the range B2:B10 that are "Math" and the corresponding cells in the range C2:C10 that are greater than 95. 
=COUNTIFS(B2:B10, "Science", C2:C10, ">95")
counts the number of cells in the range B2:B10 that are "Science" and the corresponding cells in the range C2:C10 that are greater than 95.

SUM Formula
 The SUM formula is used to calculate the total value of a range of cells.
 The syntax for the SUM formula is
=SUM(range)
.  Examples:

=SUM(D2:D4)
calculates the total cash reward earned by Kristine. 
=SUM(D5:D7)
calculates the total cash reward earned by Kazie. 
=SUM(D8:D10)
calculates the total cash reward earned by Kerwin.

SUMIF Formula
 The SUMIF formula is used to calculate the total value of a range of cells that meet a specified condition.
 The syntax for the SUMIF formula is
=SUMIF(range1, criteria1, range2)
.  Example:
=SUMIF(B2:B10, "Math", D2:D10)
calculates the total cash reward earned in the Math subject.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.