One "Total" line for each value in a certain column

[wad11656]

Instead of a single "Total" line, I'd like the "Total" line to be split into 2 by the values in the "OPC" column: 1 "Total" line for "ANCILLARY PRODUCT" and 1 "Total" line for "Main Product". Is this possible?

Despite the misleading edits (made for company privacy reasons), I want to clarify that I already have all the data I need in my screenshot, apart from the last 2 lines I manually typed in.

 

[SanjayGMusafir]

Simple SUMIFS function can do the job for you. It gives you option to add multiple criteria to test before totalling.

Also you haven't mentioned the version of Excel you are using. The actual solution can vary from version to version.