Add formulas and functions

Updated November 3, 2026

Formulas in Cloud Sheets by MyCloudSuites work the way they do in Excel, and the results match Excel’s.

Type a formula

1. Click the cell where you want the answer.
2. Type = and then the formula, for example =B2*C2 or =SUM(B2:B13).
3. As you type a function’s name, Cloud Sheets suggests matching functions, then shows each argument as you go.
4. Press Enter.

Add up a column with AutoSum

Click the cell under the numbers and choose AutoSum on the Home or Formulas tab. Cloud Sheets picks the cells above; press Enter to keep them, or drag over other cells first.

Find a function

Choose Formulas › Insert function and type part of a function’s name to find it. The Function Library on the Formulas tab also lists them by kind: financial, logical, text, date and time, lookup and more.

Formulas that spill

Functions that return more than one value, such as FILTER, SORT and UNIQUE, fill the cells below and beside them by themselves. Change the data and the results follow.

Check a formula

• Names: give a cell or range a name on Formulas › Defined Names, then use the name in formulas.
• Where a value comes from: the Formula Auditing group on the Formulas tab traces the cells a formula uses, and the formulas that use a cell.