Help in SUMIF Formula

Hi to All,

I need your help on how to create a SUMIF Formula in Column I, please find attached Excel File. The result should look like in Column J:

Many thanks.

Regards,

Aryan

If you layout the data in a structured format, then a Pivot table would do the trick for you.

Hi Admin,

I need to keep the format of the table for reporting purposes. However, if that will be possible for the Pivot Table to keep the same format, will you be able to help and assist me on how to do it using Pivot Table.

Many thanks in advance!

Regards,
Aryan

Unfortunately, the current format doesn't help to create the pivot.