Changes
Jump to navigation
Jump to search
← 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
Navigation menu
Personal tools
Log in
Namespaces
Page
Discussion
Variants
Views
Read
View source
View history
More
Search
Navigation
Main page
Community portal
Current events
Recent changes
Help
Tools
ZCubes Web Platform
Printable version