Texas Instruments NS/CLM/1L1/B Reference Guide - Page 86
Criteria, SumList, value, sumList, Value1, Value2, Value3, Matrix1, matrix
 |
UPC - 033317190256
View all Texas Instruments NS/CLM/1L1/B manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 86 highlights
sumIf( ) sumIf(List,Criteria[, SumList]) ⇒ value Returns the accumulated sum of all elements in List that meet the specified Criteria. Optionally, you can specify an alternate list, sumList, to supply the elements to accumulate. List can be an expression, list, or matrix. SumList, if specified, must have the same dimension(s) as List. Criteria can be: • A value, expression, or string. For example, 34 accumulates only those elements in List that simplify to the value 34. • A Boolean expression containing the symbol ? as a placeholder for each element. For example, ? Catalog > Catalog > 80 TI-Nspire™ Reference Guide
-
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
-
49
-
50
-
51
-
52
-
53
-
54
-
55
-
56
-
57
-
58
-
59
-
60
-
61
-
62
-
63
-
64
-
65
-
66
-
67
-
68
-
69
-
70
-
71
-
72
-
73
-
74
-
75
-
76
-
77
-
78
-
79
-
80
-
81 -
82 -
83 -
84 -
85 -
86 -
87 -
88 -
89 -
90 -
91 -
92
-
93
-
94
-
95
-
96
-
97
-
98
-
99
-
100
-
101
-
102
-
103
-
104
-
105
-
106
-
107
-
108
-
109
-
110
-
111
-
112
-
113
-
114
-
115
-
116
-
117
-
118
-
119
-
120
-
121
-
122
-
123
-
124
-
125
-
126
-
127
-
128
-
129
-
130
 |
 |
80
TI-Nspire™ Reference Guide
T
sumIf()
Catalog >
sumIf(
List
,
Criteria
[,
SumList
]
)
⇒
value
Returns the accumulated sum of all elements in
List
that meet the
specified
Criteria
. Optionally, you can specify an alternate list,
sumList
, to supply the elements to accumulate.
List
can be an expression, list, or matrix.
SumList
, if specified, must
have the same dimension(s) as
List
.
Criteria
can be:
•
A value, expression, or string. For example,
34
accumulates only
those elements in
List
that simplify to the value 34.
•
A Boolean expression containing the symbol
?
as a placeholder
for each element. For example,
?<10
accumulates only those
elements in
List
that are less than 10.
When a
List
element meets the
Criteria
, the element is added to the
accumulating sum. If you include
sumList
, the corresponding element
from
sumList
is added to the sum instead.
Within the Lists & Spreadsheet application, you can use a range of
cells in place of
List
and
sumList
.
Note:
See also
countIf()
, page 18.
system()
Catalog >
system(
Value1
[
,
Value2
[
,
Value3
[
,
...]]]
)
Returns a system of equations, formatted as a list. You can also
create a system by using a template.
T (transpose)
Catalog >
Matrix1
î
⇒
matrix
Returns the complex conjugate transpose of
Matrix1
.