Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

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.
H
AA
AD
AE
FO
V
X
C
FN
FF
FS
FG
FK
1
2
3
AF
B
FC
FC
AG
FA
AT
AM
AB
AL
AC
AR
5
6
W
M
FM
AH
AN
P
K
0
9
AI
I
D
O
AJ
U
FI
E
S
FD
AK
T
N
E
PI
T
F
P
K
C
N
Q
B
A
D
O
G
I
P
A
B
M
O
SZ
C
D
PG
PH
M
A
U
I
L
T
E
O
G
Q
C
X
B
J
A
A
SA
SD
T
C
Y3
B
V
R
A
C
T
D
D
W
A
B
C
D
VG
VH
E
G
H
F
JT
B
A
D
G
E
O
T
R
C
N
U
F
H
JP
B
AF
AE
JC
A
C
B
W
E
D
L
F
S
JA
A
B
C
D
E
F
G
H
JO
B
AF
AE
AN
A
F
I
B
E
V
C
L
H
DE
A
T
G
P
B
C
W
H
R
U
  • Undo

    Undo
    po
  • Clipboard

    Clipboard
    po
  • v
    v
    popopopo
    Font

    Font
    po
  • Alignment

    Alignment
    po
  • po
    dialogboxlauncherNumber

    Number
    po
  • Cells

    Cells
    po
  • Editing

    Editing
    po
  • Styles

    Styles
    po
  • dialogboxlauncherPage Setup

    Page Setuppo
  • dialogboxlauncherPrint

    Print
    po
  • Document Views

    Document Viewspo
  • Show

    Show
    po
  • View

    View
    po
  • Window

    Window
    po
  • Properties

    Properties
    po
  • Tools

    Tools
    po
  • Table Style Options

    Table Style Optionspo
  • Table Style Options

    Table Style Optionspo
  • Layout

    Layout
    po
  • PivotTable Style Options

    PivotTable Style Optionspo
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
Product
Order date
Delivery date
Qty.
Not delivered, Qty.:
Apples
86
Apricots
14-Sep
85
Bananas
7-Nov
55
Cherries
13-Sep
20-Sep
82
Lemons
1-Oct
78
Oranges
15-Oct
18-Oct
67
Peaches
16-Sep
22-Sep
72
Pears
23-Sep
29-Sep
64
 
SUM
SUMIF
SUMIFS
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
Adds all the numbers in a range of cells.
Did this demo address your needs?
If you’d like us to extend this demo further, please describe your needs below.
Thank you in advance for your cooperation.
SEND FEEDBACK

Formulas are one of the most commonly used features of spreadsheets. With the DevExpress ASP.NET Spreadsheet (ASPxSpreadsheet), 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 ASPxSpreadsheet'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 ASPxSpreadsheet'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.

Collapse/Expand
Local Copy of this Demo
To 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
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxSpreadsheetDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxSpreadsheetDemos
Segoe UI