Bob789
01-25-2018, 10:40 AM
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
=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