DSUM with Named Ranges

[Peter Bebbington]

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

 

[Debra Dalgleish]

Remove the Nominal Code heading in the criteria area, or change it to a
heading that's not in the main table.
In the criteria cell that says Staff, replace with a formula that refers
to the first data cell in the Nominal Code column of the main table. For
example:

=COUNTIF(Staff,B2)

where Nominal Code is in column B.

 

[Peter Bebbington]

Debra
Many thanks I will give it a whirl

 

[Debra Dalgleish]

You're welcome! If it doesn't do what you need, post another message
here, with more details.