From the table below in Excel I want to do a dsum for each unique Item as shown to the right. I think this is a data table function but I am not sure how to this for multiple rows. Any suggestions. Thank you.
=DSUM(B14:N190,N14,B8:B9) Unit Adjustment Unit Adjustment Unit Adjustment 1 0003 01 C 25.00 0003 01 C 2 0005 01 C 25.00 0005 01 C 3 0005 01 C 25.00 4 0005 01 C 25.00 5 0005 01 C 25.00 6 0005 01 C -100.00