Excel & Google Sheets Formula Examples
Popular tasks and ready solutions. Click on an example to generate the formula.
Excel Formulas Examples
These formulas work in Microsoft Excel and can be adapted for Google Sheets.
Sum by Date Condition
Request:
"Sum all cells in column A if date is today"
Formula:
=SUMIF(A:A, TODAY(), B:B)
Description:
This formula sums values in column B where the date in column A equals today's date.
Percentage of Total Sum
Request:
"Find percentage of total sum"
Formula:
=A1/SUM(A:A)*100
Description:
Calculates the percentage ratio of the value in cell A1 to the sum of all values in column A.
Sum with Multiple Conditions
Request:
"Sum values in column C where A is greater than 100 and B equals "Sold""
Formula:
=SUMIFS(C:C, A:A, ">100", B:B, "Sold")
Description:
Sums values in column C when multiple conditions are met simultaneously.
Extract Text After Character
Request:
"Extract text after @ symbol"
Formula:
=MID(A1, FIND("@", A1)+1, LEN(A1))
Description:
Extracts the portion of text that appears after the specified character.
Difference Between Dates
Request:
"Calculate the difference between two dates in days"
Formula:
=B1-A1
Description:
Calculates the number of days between two dates. Cell format must be "Date".
Count Unique Values
Request:
"Count the number of unique values in column A"
Formula:
=SUMPRODUCT(1/COUNTIF(A:A, A:A))
Description:
Counts the number of unique (non-repeating) values in the specified range.
Find Maximum Value by Condition
Request:
"Find the maximum value in column B where A equals "January""
Formula:
=MAXIFS(B:B, A:A, "January")
Description:
Finds the maximum value in a range when the specified condition is met.
Combine Text from Multiple Cells
Request:
"Combine text from columns A, B, and C with a space"
Formula:
=CONCATENATE(A1, " ", B1, " ", C1)
Description:
Combines text from multiple cells into one string with the specified separator.
Google Sheets Formulas Examples
These formulas work in Google Sheets and can be adapted for Excel. The same examples above work in both platforms.
Need a Different Formula?
Describe your task in natural language, and our AI will generate a formula specifically for you.
Start Free