(Excel examples for Beginners) In this end-to-end excel example, you will learn – How to Subtotal by category in Excel.   How to Subtotal by category in Excel Generic formula =SUMIF(color_range,criteria,number_range) Explanation If you need to subtotal numbers by color, you can easily do so with the SUMIF function. In the example shown, … Continue reading Excel formula for Beginners – How to Subtotal by category in Excel