Summing Values Automatically based off two sets of Categories

Hello everyone,

I hope someone can help me with this formula creation.

As the title describes, I'd like to sum the values in Column E, based on their Category in Column C, but I also want these values to be then Sub-Categorized based on person or shared. These values would then be projected within the tables to the right of the main.

Please see the link below to a file example of what i am trying to achieve. Any help would be apprciated.

https://www.dropbox.com/sh/macycabsv...c_uOQCOaa?dl=0

Regards,
silentdom11

Hello and welcome to the forum. Try these:

J3 =SUMIF(C:C,I3,E:E)

M3 =SUMIFS(E:E,C:C,L3,D:D,"BOB")

P3 =SUMIFS(E:E,C:C,L3,D:D,"LYNA")

Note that you can share your files directly to this site by clicking on GO ADVANCED and then scrolling down to Manage Attachments to open the upload window.

That works perfectly! thank you so much.

You're welcome. Thanks for the rep!