Instructions

1. Create a SUMIF function.
2. Add absolute references to lock cell references.
3. Copy the function to the other categories.
4. Double-check your math.