SUMIF formula Advanced Excel example

SUMIF formula Advanced Excel example

SUMIF

Excel SUMIF Function sums cells that match given criteria. It is very useful function which helps determining sum of particular category in a range. In this article we will see how SUMIF function works in Excel.

Data source

Syntax

=SUMIFS (range, criteria, sum_range)

Formula

=SUMIF(A2:A21,"A",C2:C21)

Output

Please leave your comments or queries under comment section also please do subscribe to out blogs to keep your self upto date.

Leave a Reply

Your email address will not be published.