Decision making

[Steel]

Anyone able to help with this little problem?

I need to set up a decision type

If any cells in column A are 1 then add the cells in column D which are in the rows where 1 is in column A, If any cells in column A is 2 then add the cells in column D which are in the rows where 2 is in column A, if any cells in column A is 3 then add the cells in column D which are in the rows where 3 is in column A, etc, etc.

Hope someone can help.

Thanks

 

[DonkeyOte]

can you not do a sumif?

ie.

sumif(a1:a5000,1,d1:d5000)
sumif(a1:a5000,2,d1:d5000)

etc...