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)
It Sums the Sales of the Criteria provided on formulae