DSUM function
=DSUM(Database,"Remaining Vacation Leave",F1:F2)
where F1 holds the header Remaining Vacation Leave and F2 is blank, if you
need other criteria just add a headers in the same order as in the database
and see help for further instructions
--
Regards,
Peo Sjoblom
"Debra Lisa" wrote in message
...
Thanks for the info, but I'm required to used the DSUM function.
I'm a CIS student and this was a review assingment and I'm missing the
concept.
Thanks anyway.
DLLewis
"OssieMac" wrote:
Hi again Debra,
Third paragraph should read Then simply ENTER the numbers not center.
Regards,
OssieMac
"OssieMac" wrote:
Hi Debra,
Is a different function acceptable? If so try the following:-
In the Vacation leave column instead of using text values of 17-day
etc;
custom format these cells using:-
Number format-number-custom and insert 0"-day" as the format.
Then simply center the numbers (17,12,7 and use 0 for none). The
display
will have the '-day' appended to it but you can then use the actual
values of
17,12,7 and 0 in formulas.
Formula for Days Remaining:-
=SUMIF($D$2:$D$100,H2,$F$2:$F$100)
Whe
$D$2:$D$100 is from Vacation Leave column in Database
H2 is from the column containing Vacation Leave in the summary
$F$2:$F$100 is from the Remaining Vacation leave column in database.
Hope it helps,
Regards,
OssieMac
"Debra Lisa" wrote:
Need to use the DSUM function to calculate the total number of
vacation days
remaining. Please help, I have been stumped for 2 days now.
Leave Summary
Vacation Leave Number Eligible Total Days Days Remaining
17-day 36 612
12-day 29 348
7-day 6 42
none 31 0
Total 102 1002
the database is:
Name Status Yrs Employed Vacation Leave Used Vacation Leave Remaining
Vacation Leave
Abba FT 0.1 7 5 2
Abbot FT 4.0 12 7 5
Adtkins FT 5.7 17 4 13
Andrews FT 8.8 17 3 14
Baker PT 2.5 0 0 0
Berg FT 4.5 12 4 8
Bergeman FT 10.0 17 4 13
Blake CN 0.3 0 0 0
Please help.
--
DLLewis
|