hi,

I have a real problem - that is getting to me, ok here goes

sheet 1 lists transactions by departments

on sheet 2 I would like to be able to add up the transactions for each dept.
The problem is that the dept is column D but the amount is Column I

any ideas ?

David