Need array to sum based on multiple criteria

Hello,

[SEE REPLY POST BELOW FOR UPDATED FILE]

Basically I need an array that will sum up one column based on criteria from others.

Below is a snip of a super simplified version of what I've got:

Capture.PNG

Now if it loaded correctly there should be 4 columns. I need an array that will sum up the total items in store for the first instance of a store, But I want it summed by state. So without a formula, I want to sum total Items in store for NY. I only want the first instance of each store in NY which would be the sum of 220 and 75. This is where I want to end. Keep in mind this is overly simplified and my actual table is tens of thousands of rows.

I think I'm close with this formula but can't get it to work correctly.
{=IF(COUNTIFS(C:C,"NY",INDEX(A:A,MATCH(A:A,A:A,0)):A:A,A:A)=1,SUM(INDEX(D:D,MATCH(A:A,A:A,0)):A:A,A:A),"0")}


Any help would be greatly appreciated.