I have an excel sheet with three worksheets.
1. Database from which the final values is looked from ("NetData")
2. Database that provides the IDs for lookup ("Template")
3. Final sheet where the value is posted

I am performing following ways for DSUM to work
=DSUM(NetData!A1:K313,"LENGTH",NetData!L1:L2)
=DSUM(NetData!A1:K313,"LENGTH","""AASEGNO"&"="&Tem plate!V5&"""")
=DSUM(NetData!A1:K313,"LENGTH",NetData!A1=Template !V5)
=DSUM(NetData!A1:K313,"LENGTH","AASEGNO"=Template! V5)

The variable "Length" is being summed up. The criteria - NetData!L1:L2 works
where the I have manually entered what I have being trying to do in the three
other ways where I make the value NetData!L2 as to be a variable having a
value that is contained in Template sheet, the only difference is that in
first one I can only enter one value Template!V5. Can anybody help with why
the last three ways of setting up the criteria is wrong along with the
correction?