Open main menu
Home
Random
Log in
Settings
About ZCubes Wiki
Disclaimers
ZCubes Wiki
Search
Changes
← Older edit
Newer edit →
Manuals/calci/SUMIF
(view source)
Revision as of 21:54, 3 July 2018
79 bytes removed
,
21:54, 3 July 2018
no edit summary
Line 1:
Line 1:
<div style="font-size:30px">'''SUMIF (Array,Condition,SumArray)'''</div><br/>
<div style="font-size:30px">'''SUMIF (Array,Condition,SumArray)'''</div><br/>
−
SUMIF(CriRange, Criteria, SumRange)=
−
where
where
*<math>Array</math> is the range of cells that is evaluated by the specified criteria,
*<math>Array</math> is the range of cells that is evaluated by the specified criteria,
Line 7:
Line 5:
*<math>SumArray</math> is the actual range of cells to be added.
*<math>SumArray</math> is the actual range of cells to be added.
−
SUMIF()
calculates the sum of values in
the given
range if the specified
criteria
is satisfied
.
+
SUMIF()
, adds
the
cells specified by a
given criteria.
== Description ==
== Description ==
Devika
writer
6,694
edits