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

another quetion with my homework.
Use the DSUM function to calculate the total number of vacation days
remaining.
I put in this: =DSUM('Employee Data'!E6:E109,"17",D4)
You do this for days remaining. I get the E6:E109 from the Employee Data
sheet that Is titled Remaining Vacation Leave. I get the D4 from my leave
summary sheet that shows the total days as 612. You do this for 17 day vac,
12 days of vacation,7 and then 0. I get an error #VALUE Not sure what to do
or where to go with this.
--
Too old to be in college
 
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
Using the function DSUM Tom Excel Discussion (Misc queries) 7 September 26th 07 11:43 PM
DSUM function Debra Lisa Excel Worksheet Functions 8 August 29th 07 03:24 PM
DSUM - Modifying the function... DKIM Excel Worksheet Functions 1 December 29th 06 10:44 PM
Prom with the DSUM function oteixeira Excel Worksheet Functions 3 June 12th 06 04:41 PM
DSum function Mark Excel Worksheet Functions 2 November 17th 04 02:47 PM


All times are GMT +1. The time now is 09:11 PM.

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

About Us

"It's about Microsoft Excel"