Skip to main content

SUM, SUMIF & SUMIFS Functions

When are they used:

SUM :- allows for the summation of a specific number of cells, both adjacent and non-adjacent.


=SUM(Start Range, End Range)

 SUMIF :- allows for the summation of a range of cells that meet a specific criterion.


=SUMIF(Criterion Range, Criterion, Sum Range)

SUMIFS :- allows for the summation of a range of cells that meet a number of different criteria.


=SUMIFS(Sum Range, Criterion Range 1, Criterion 1, Criterion Range N, Criterion N)

Leave a Reply

Your email address will not be published.

Share via
Copy link
Powered by Social Snap