thank you very much. Yes these are a _____. I could not find anything
anywhere explaining them well enough. Our book has one example and does not
go into any detail about it.
thanks again.
KIM
--
Too old to be in college
"T. Valko" wrote:
The D functions are rather ______ and you'll see why in a second.....
I gave your data on sheet Employee Data A5:I107 the defined name of Table.
I entered this data on sheet Leave Summary as the criteria range to be used
by the DSUM function:
Leave Summary:
B11:D11 = Vacation Leave, Vacation Leave, Vacation Leave
B12:D12 = 17, 12, 7
I entered this formula on sheet Leave Summary in cell E4 and copied down to
E6:
=DSUM(Table,6,INDEX(B$11:D$12,,ROWS(E$4:E4)))
These are the correct results:
17 - 456
12 - 238
7 - 23
--
Biff
Microsoft Excel MVP
"Kimmer" wrote in message
...
Leave2.xls
--
Too old to be in college
"Gord Dibben" wrote:
The news reader has messed up your data layout considerably so can't tell
what
data is in which columns.
You can post the workbook at one of the hosting sites below.
http://www.freefilehosting.net/
http://savefile.com/
When you have uploaded to that site, post the URL so we could download
should we
choose.
Gord
On Sat, 19 Apr 2008 12:47:00 -0700, Kimmer
wrote:
I am doing this for school and the example they give in book does not
help
and I have been to every site there is plus books looking for help.
Book says: In the range E4:E7, use the DSUM function to calculate the
total
number of vacation days remaining.
This is my Employee Data worksheet
A5 B5 C5 D5 E5 F5
G5 H5 I5
Name Status Yrs Empl Vaca Used vac Remaining Family Used
Fam
Rema
leave leave vac leave
Leave Leave Fam L
Abba FT 0.1 7 5 2
3 0 3
and so on down the list of 109 names
My Leave Summary worksheet:
B3 C3 D3
E3
Vacat Leave Number Eligible Total Days Days Remaining
17-Day 36 612
12-day 29 348
7 day 6 42
none 31 0
Total 102
I tried this formula and I get 698 and the total should be like 456
=DSUM('Employee Data'!A5:I109,"Remaining Vacation Leave",D3:E7)
I have tried others doing B3:E7 for criteria and get 0 for the total.
You
have to do this for each vacation leave day. I cant get it to give me
the
right answer for the first one let alone any of the others.
Thank you in advance if you have any ideas