ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   "+" in DSUM field? (https://www.excelbanter.com/excel-worksheet-functions/66992-dsum-field.html)

Sarah Jane

"+" in DSUM field?
 
I have inherited a spreadsheet with SDUM functions, but I dont 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 cant 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?



All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com