There are a zillion posts about DSUM, but I don't know how to find ones that answer my question without reading all zillion -- searching titles hasn't helped much.

I'm fair to middling at Excel, including VBA, but have never used any database functions up to now. I tried to put in =DSUM(PersonsRange,"AgeGroup","Under 35") and got a #VALUE error. Put the rangename in quotes too, same. Tried = signs in various ways with the criterion, same. What am I doing wrong?

Oh -- also tried using the column number in place of the "AgeGroup," same result.