Excel: more functions

To find the highest number

• =max(a1:a8)

• =max(a2:a8)

To sum all the numbers less than 33

• =sum(a2:a8,<33)

• =sumif(a2:a8,"<33")

To count all the numbers

• =countif(a2:a8)

• =count(a2:a8)

To find the average of all the numbers

• =avg(a2:a8)

• =sum(a1+a2+a3+a4+a5+a6+a7+a8)/7

• =average(a2:a8)

To add 2 numbers 12 and 55

• =sum(a2:a6)

• =a2+a6

According to a given criteria if age is greater than or equals to 18 display "License Granted" else "Denied". The age is in cell a4

• =if(a4>=18,"License Granted","Denied")

• =if(a4 >=18,License Granted,Denied)

• =if(a4>18,"License Granted","Denied")

What is the formula to count the number of text values

• =COUNTA(A1:C1)

• =COUNT(A1:C1)

To add all the numbers

• =sum(a2:a8)

• =sumif(a2:a8)

To find the lowest number

• =minimum(a2:a8)

• =min(a2:a8)

To add all the numbers less than 55

• =sumif(a2:a8,"<55")

• =sumif(a2:a8,<55)

• =sum(a2:a8,"<55")