I am using Dsum() in Excel 2003. If I use a range name for the criteria it
all works fine and gives me the expected result. However, if I use the "fx"
button to look at my formula it shows a red #value! error against the
criteria box. This does not happen if I define the criteria range as B1:D2
for example.
As I say it all works ok even with this error showing I was just wondering
what is going on. Is there some subtle error that could give me problems
later on if I just ignor this.
As usual many thanks in advance for any advice you can give me. Peter