LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default DSUM function

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DSUM - Modifying the function... DKIM Excel Worksheet Functions 1 December 29th 06 10:44 PM
Still a problem with DSUM function oteixeira Excel Worksheet Functions 0 June 13th 06 05:27 PM
Prom with the DSUM function oteixeira Excel Worksheet Functions 3 June 12th 06 04:41 PM
How do I add a second criteria to the SUMIF or DSUM function? jlpwilley Excel Worksheet Functions 2 January 12th 06 04:44 PM
DSum function Mark Excel Worksheet Functions 2 November 17th 04 02:47 PM


All times are GMT +1. The time now is 12:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"