Jan 03 2014 07:58 PM
The count formula counts the number of cells in a range that have numbers in them.
The LEN formula counts the number of characters in a cell. Be careful though! This includes spaces.
Gets rid of any space in a cell, except for single spaces between words.
NOW Returns the system date and time
TODAY Returns the system date, without the time
SUMIF Calculates a sum from a group of values, but just of values that are included because a condition is met
COUNTIF Counts the number of cells in a range that match a criteria