PDA

View Full Version : Dsum and Data Tables



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

paulked
01-25-2018, 02:02 PM
21457

I think SUMIF is what you are looking for, see attached file.

Bob789
01-25-2018, 04:35 PM
Fantastic. That's it. Thank you very much

paulked
01-25-2018, 05:26 PM
You're welcome, don't forget to mark the thread 'Solved'

Cheers