Help in SUMIF Formula

[Aryan063007]

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

[Admin]

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

[Aryan063007]

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

[Admin]

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