![]() |
"+" 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