Sum all only once with column containing potential duplicates

[helpmeplz_]

I have 7 columns that I have "automated," but now they don't like the automation because the dataset must be sorted a to z to function. Can you help me re-automate these functions so the data doesn't need to be sorted a to z?

=IF($A4=$A5,"",SUMIFS($I:$I,$A:$A,$A4))

=IFERROR(IF($A4=$A5,"",SUMIFS($N:$N,$A:$A,$A4))+IF($A4=$A5,"",SUMIFS($P:$P,$A:$A,$A4)),"")

=IF($A4=$A5,"",SUMPRODUCT(($A$4:$A$1000=$A4)*($B$4:$B$1000)*$K$4:$K$1000)/$L4)

Column A is just data that was originally sorted a to z to automate, starting at A4 but would now be unsorted. Trying to not double count data because it's based on column A and column A will now not be sorted.

Column A
A4 Amazon
A5 Amazon
A6 Best Buy
A7 Amazon
A8 Best Buy
A9 Target
A10 Amazon

 

[helpmeplz_]

I think it should work... Seems correct...

This worked

 

[SanjayGMusafir]

=IFERROR(IF($A5=$A6,"",SUMIFS($N:$N,$A:$A,$A5))+IF($A5=$A6,"",SUMIFS($P:$P,$A:$A,$A5)),"")

Can't understand the need of IFERROR

Check this and revert -

=IF(Countifs($A$4:$A5,$A5)>1,"",SUMIFS($N:$N,$A:$A,$A5)+SUMIFS($P:$P,$A:$A,$A5))

 

[helpmeplz_]

Thank you! This all worked great!

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.