Functions

Count Cells with Numbers.

   =COUNT(value1, value2,...value30). 

NOTE: Any cells that contain text or a combination of text and numbers will be ignored.

 Returns the current date.

e.g:

e.g.:
if you want to extract the last 4 digits of the phone number, you use this time the function RIGHT as follow:

A condition AND returns TRUE if and only if all tests in parenthesis are true.

=AND(test 1,test 2,test 3, …)

A condition OR returns TRUE if one (or more) tests of the function is true.

= OR(test 1,test 2,test 3, …)

e.g:

In the following table, you have a shopping list of equipment and want to know how often you sale CD-ROM.

=COUNTIF(B3: B12,”CD-Rom”)