Themes

Formulas

On the AutoComplete list, double-click on the SUMIFS function (or press the Tab key if SUMIFS is selected) to insert this function into the cell formula, and then press Enter to evaluate the formula.
• Undo

Undo
• Clipboard

Clipboard
• Font

Font
• Alignment

Alignment
• Number

Number
• Cells

Cells
• Editing

Editing
• Styles

Styles
• Tables

Tables
• Illustrations

Illustrations
• Charts

Charts

• Page Setup

Page Setup
•  Gridlines
Print

Print
• Function Library

Function Library
• Calculation

Calculation
• Sort & Filter

Sort & Filter
• Data Tools

Data Tools

• Document Views

Document Views
•  Gridlines
Show

Show
• View

View
• Window

Window
• Properties

Properties
• Tools

Tools
 Total Row
 Banded Columns
 First Column
 Last Column
 Banded Rows
Table Style Options

Table Style Options
• Table Style Options

Table Style Options
• Arrange

Arrange
• Type

Type
• Data

Data
• Chart Layouts

Chart Layouts
• Chart Styles

Chart Styles
• Labels

Labels
• Axes

Axes
• Arrange

Arrange
• Data

Data
• Actions

Actions
• Show

Show
• Layout

Layout
 Banded Rows
 Banded Columns
PivotTable Style Options

PivotTable Style Options
﻿

Formulas are one of the most commonly used features of spreadsheets. With the DevExpress ASP.NET MVC Spreadsheet, you can easily insert and calculate formulas in a manner similar to Microsoft Excel.

A formula is a string expression that begins with an equal (=) sign. It can contain constants, operators, cell references, functions and names.

The Spreadsheet's built-in functions cover a wide range of categories - from basic mathematical operations such as simple addition and subtraction, to complex engineering and statistical calculations. This can meet even the most demanding requirements. The function categories provided include:

• Financial
• Statistical
• Engineering
• Logical
• Text
• Date & Time
• Lookup & Reference
• Math & Trig
• Informational

The built-in functions are listed within an Excel-like Formulas tab in the Spreadsheet's automatically generated Ribbon. In this tab, functions are divided into groups for easy access.

A formula can contain references to other cells or cell ranges within the same or different worksheets. The following references are supported:

• Relative, Absolute and Mixed References
• Cross-Worksheet References
• 3D References
• Structured References
• External References

Note: The Formula AutoComplete feature makes it easier to create and edit formulas and minimizes typing and syntax errors. After typing an equal sign (=) and beginning letters into a cell, a dynamic drop-down list of valid functions that match the letters is displayed below the cell. For a function selected within the list, a text tooltip with function information is displayed. This helps choosing the right function. To insert the selected item into the formula and put the insertion point directly after it, press Tab or double-click the item.

See how formulas are used in this demo on both sheets.

 Local Copy of this DemoTo inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer. You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher). Open CS Solution The source code files for this demo are installed (by default) in the following directory:\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxSpreadsheetDemos