Daily used Excel and Google Sheets formulas to supercharge your productivity

• Sum by month

• SUMIF cells if contains part of a text string

• Sum total sales based on quantity & price

• Combine date and time

• Convert 1-12 to month name

• Dynamic current date and time

• Count blank cell

• Count cell between two values 

• Count cells that contain numbers and ignore blank

• Count cells that do not contain numbers and ignore blank

• Combine two or more cell

• Combine multiple columns into one single column

• Extract left before first space

• Extract right after first space

• Extract the nth words in a text string

• Extract domain URL from a link

• Flip the first and last name

• Transpose column to row and ignore blank

• Transpose row to column and ignore blank

Widely used Excel and Google Sheets functions explained

• SUMIF formulas and example

• SUMIFS formulas and example

• COUNTIF formulas and example

• IF formulas and example

• TEXT formulas and example

• CONVERT formulas and example

Sum functions based on criteria — Excel & Google Sheets example

• Sum by month

• SUMIF cells if contains part of a text string

• Sum total sales based on quantity & price

• Calculate running total

Change number sign — Excel & Google Sheets example

• Change the negative number to zero

• Change negative to positive numbers

• Change positive numbers to negative

• Remove negative sign from numbers

• Calculate percentage changes for containing zero or negative values

Date and time functions — Excel & Google Sheets example

• Combine date and time

• Convert date to text

• Convert time to text

• Convert seconds to time format

• Convert 1-12 to month name

• Convert month name to number

• Convert date to month and year

• Convert numbers of days to year/month/day

• Dynamic current date and time

• Dynamic current time

• Dynamic today and yesterday date

• Convert number stored as a text to date

• Convert weekday string to number

Currency conversion functions — Google Sheets example

• Convert EURO to USD in Google Sheets

• Convert USD to EURO in Google Sheets

Combine cells and columns data — Excel & Google Sheets example

• Combine two or more cell

• Combine multiple columns into one single column

• Combine two or more cells with a line break

• Combine two or more cells and transpose

• Combine data from multiple Google Sheets tabs and get sheet/tab name

Convert functions — Excel & Google Sheets example

• CONVERT formulas and example

• Convert alphabet letter to number

• Convert decimal numbers to binary

• Convert letter to number

• Convert number to alphabet letter

• Convert number to roman number

• Convert number with two decimals

• Convert roman number to number

• Convert number stored as a text to date

• Convert weekday string to number

Count functions — Excel & Google Sheets example

• Number based criteria in Excel and google sheets

  • Count blank cell

  • Count cell between two values

  • Count cells greater than

  • Count cells greater than and equal to

  • Count cells less than

  • Count cells less than and equal to

  • Count cells not equal to

  • Count cells that contain numbers and ignore blank

  • Count cells that do not contain numbers and ignore blank

  • Count number of days between dates

• Text-based criteria — Excel & Google Sheets example

  • Count cells in the column that have the same first five characters

  • Count cells over 10 characters

  • Count cells that are not blank

  • Count if cells contain a specific text

  • Count cells that begin with a specific text

  • Count cells that contain a specific text and ignore blank

  • Count cells that contain errors

  • Count if cells start with a specific text

  • Count if cells end with a specific text

  • Count the number of words in a cell

  • Count the number of cells that have more than 5 characters words in a column

  • Count the number of occurrences of a text string in a range

  • Count words in a range of cells and columns

  • COUNTIF based on multiple criteria

Extract functions — Excel & Google Sheets example

• Extract left before first space

• Extract right after first space

• Extract the nth words in a text string

• Extract domain URL from a link

• Extract URL domain root

• Get text between colons

• Get text between commas

• Get the last non-empty cell in a column

• Get the first non-empty cell in a column

• Extract text inside characters (parentheses)

Change the text position — Excel & Google Sheets example

• Flip the first and last name

• Move the first word to the end

• Reverse the text strings within cells

• Capitalize the first letter of every word

• Capitalize only the first letter

• Split words by uppercase in Google Sheets

Transpose functions — Excel & Google Sheets example

• Transpose column to row

• Transpose column to row and ignore blank

• Transpose row to column

• Transpose row to column and ignore blank

Unit conversion functions — Excel & Google Sheets example

• Convert kilograms to pounds

• Convert kilograms to stones

• Convert pounds to kilograms

• Convert stones to kilograms

• Convert acres to hectares

• Convert hectares to acres

Advance Google Sheets function example

• Get sheet name in Google Sheets

• Combine data from multiple Google Sheets tabs and get sheet/tab name

• Split words by uppercase in Google Sheets