Scribd
Upload
3 views

010 (A) Ms-Excel Functions

Uploaded by

ellis.ndungu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views

010 (A) Ms-Excel Functions

Uploaded by

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

Function Used for Format Example Tips

Add values in a
=SUM(range of cells to add) =SUM(A1:A10)
SUM range of cells
Average the
=AVERAGE(range of cells to
values in a range =AVERAGE(A1:A10)
average)
AVERAGE of cells
Find the highest
value in a range =MAX(range of cells) =MAX(A1:A10)
MAX of cells
Find the lowest
value in a range of =MIN(range of cells) =MIN(A1:A10)
MIN cells
Display different
information =IF(condition test, what to display if
=IF(A1>20, “Great!”,”Oops!”) or
depending on the outcome is true, what to display if
=IF(A1>20, A1*E1,A1)
outcome of a outcome is false)
IF condition test
TRUE and FALSE
are the only
Test that more possible answers.
than one condition To change the
is true.
content of a cell
=AND(condition test 1, condition test as the result of an
Test result is =AND(A1>20,B1=”Gold”)
2, ...)
TRUE only if all AND function, use
conditions are the AND function
met. as the condition
test in an IF
AND statement
Test that more
than one condition
is true. =OR(condition test 1, condition test
=OR(A1>20,B1=”Gold”)
2, ...)
Test result is
OR TRUE if any of the
conditions are
met.

COUNT does not


count
Count numerical
=COUNT(range of cells to count) =COUNT(A1:A10) cells containing
cells text, use
COUNT COUNTA for this
Count cells =COUNTA(range of cells to =COUNTA(A1:A10)
COUNTA count)
=COUNTBLANK(range of cells to
Count empty cells =COUNTBLANK(A1:A10)
COUNTBLANK count)
Count cells that =COUNTIF(A1:A10,”>20”)
=COUNTIF(range of cells to Counts all cells containing a value greater than 20
meet a certain
count,critera to satisfy)
COUNTIF condition
Count cells only if =COUNTIFS( range of cells for =COUNTIFS(A1:A10,”Gold”,B1:B10,”>20”) Counts Can use pivot table
multiple conditions criteria check 1, criteria 1 to satisfy, number of rows where column A contains the word instead.
are met range of cells for criteria check 2, Gold AND column B is greater than 20
COUNTIFS criteria 2 to satisfy,...)

Function Used for Format Example Tips


Add values You only need
in a range the second
=SUMIF(range of cells for
only if cells =SUMIF(A1:A10,”Gold”,C1:C10) range if the
criteria check; criteria to
meet a Adds all cells in column C if column A contains the range to add is
satisfy, range of cells to
certain word Gold different to the
add)
condition range to be
SUMIF searched.
Add values =SUMIFS(range of cells Can use pivot
in a range to add, range of cells for table instead
criteria check 1, criteria 1 =SUMIFS(C1:C10,A1:A10,”Gold”,B1:B10,”>20”)
only if cells
to satisfy, range of cells Adds all cells in column C if column A contains the
meet word Gold AND column B is greater than 20
for criteria check 2,
multiple
criteria 2 to satisfy,...)
SUMIFS conditions

You might also like