S
Sarah Jane
I have inherited a spreadsheet with SDUM functions, but I don’t understand
the notation used in the entry for the “fieldâ€, i.e. =DSUM(database, field,
criteria). Let me see if I can explain…
DB and FIRM are defined names referring to $B$6:$EB$182 and $DS$2:$DT$3
respectively. FIRM contains properly formatted criteria.
B254=1
C254=B254+1
…
T254=S254+1
and so on such that row 254 appears to be the column number (offset by 1 due
to starting in column B).
The formula in T190 is =DSUM(DB, +T254, FIRM).
The formula in U190 is =DSUM(DB, +U254, FIRM).
…
The formula in DQ190 is =DSUM(DB, +DQ254, FIRM).
For High Potential and Other Potential, they have T191=DSUM(DB, +T254, HPOT)
and T192=DSUM(DB, +T254, OTHPOT) where HPOT and OTHPOT are defined names
similar to FIRM.
What does the “+†in front of the cell reference do? I need to create
similar rows with different criteria, but I can’t figure out what impact the
“+†makes. When using the “+â€, is using the $ in front of the 254 to keep it
from changing when coping to other rows also allowed?
the notation used in the entry for the “fieldâ€, i.e. =DSUM(database, field,
criteria). Let me see if I can explain…
DB and FIRM are defined names referring to $B$6:$EB$182 and $DS$2:$DT$3
respectively. FIRM contains properly formatted criteria.
B254=1
C254=B254+1
…
T254=S254+1
and so on such that row 254 appears to be the column number (offset by 1 due
to starting in column B).
The formula in T190 is =DSUM(DB, +T254, FIRM).
The formula in U190 is =DSUM(DB, +U254, FIRM).
…
The formula in DQ190 is =DSUM(DB, +DQ254, FIRM).
For High Potential and Other Potential, they have T191=DSUM(DB, +T254, HPOT)
and T192=DSUM(DB, +T254, OTHPOT) where HPOT and OTHPOT are defined names
similar to FIRM.
What does the “+†in front of the cell reference do? I need to create
similar rows with different criteria, but I can’t figure out what impact the
“+†makes. When using the “+â€, is using the $ in front of the 254 to keep it
from changing when coping to other rows also allowed?