I a m having a problem with DSUM criteria.

I have the following columns amongst others
ACCOUNT Type Nominal Code
BUDGET Staff

The BUDGET entry is an item in the ACCOUNT TYPE column but Staff refers to a
named range of several different codes.

If I include "Nominal Code" as the 1st entry in the "Staff" Range then I can
use INDIRECT B2 for the criteria but I then cant use the criteria in column A.

Can someone please help


--
Kind Regards

Peter Bebbington