Dsum and Data Tables

[Bob789]

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]

Ked21.xlsm

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

[Bob789]

Fantastic. That's it. Thank you very much

[paulked]

You're welcome, don't forget to mark the thread 'Solved'

Cheers