used to add all the cells in a range that match a given criteria, =COUNTA, =COUNT, =MAX, =SUMIF, used to count cells in range containing any info but not blank, =COUNT, =COUNTBLANK, =COUNTA, =COUNTIF, finds the lowest number in a list of cells, =COUNTBLANK, =MIN, =MAX, =COUNTIF, used to count all the cells in a range that match a given criteria, =COUNTIF, =COUNTA, =IF, =SUMIF, finds the highest number in a list of cells, =MAX, =MIN, =VLOOKUP, =COUNTIF, count all the cells in a range that meet multiple conditions at the same time, =COUNTBLANK, =SUMIF, =COUNTIFS, =COUNTA, adds up all the items that appear, =SUM, =COUNT, =MIN, =COUNTA, used to count all the empty cells in a range, =COUNTA, =COUNTBLANK, =MIN, =SUMIF, used to check a condition of a cell, and display a true or false answer, =COUNT, =IF, =VLOOKUP, =COUNTIF, used to alculate the average of cells based on a given criteria., =AVERAGEIF, =IF, =AVERAGE, =SUMIF
0%
IGCSE Spreadsheet Functions
Share
Share
by
Mrssherrington
Edit Content
Print
Embed
More
Assignments
Leaderboard
Show more
Show less
This leaderboard is currently private. Click
Share
to make it public.
This leaderboard has been disabled by the resource owner.
This leaderboard is disabled as your options are different to the resource owner.
Revert Options
Gameshow quiz
is an open-ended template. It does not generate scores for a leaderboard.
Log in required
Visual style
Fonts
Subscription required
Options
Switch template
Show all
Open results
Copy link
QR code
Delete
Continue editing:
?
