Requirement: Sum all of Criteria sales in excel sheet
Sum- Sums cells that meet a criteria, Range- range to apply criteria to, Criteria- criteria to apply.
=SUMIF(A4:A23, "*Nizamabad", C4:C23)
![](http://rishandigital.com/wp-content/uploads/2023/05/image-155.png)
It Sums the Sales of the Criteria provided on formulae
![](http://rishandigital.com/wp-content/uploads/2023/05/image-156.png)