✅ SUMIF Function symplyfied in Excel !!
✅ Formula: =SUMIF($J$2:$J$23,M2,$K$2:$K$23)
✅ Syntax: =SUMIF(Select the Department list & press F4 to lock the range, select criteria i.e. first cell of department, select the sum range i.e. Sales List & press F4 to lock the range)
