Wonderful, great! Thank You.
"Frank Kabel" wrote:

Hi
and there's the difference!
One name begins with row 2 and the other with row 1. Both ranges have
to start with the same row

--
Regards
Frank Kabel
Frankfurt, Germany

"Spunky" schrieb im Newsbeitrag
...
I'm not sure what you are asking for. I have checked "use labels in
my
formulas" in the tools/options/calculations. I also named the Qty
column
"currtotalqty" ='manifest summary database '!$G$2:$G$42 and the
database
range is named "msdatabase" ='manifest summary database '!$A$1:$I$42.
"Frank Kabel" wrote:
Hi
still the formulas fopr your names
msdatabase
Container
CurrTotalQTY

are missing. I suspect that they're incorrect

--
Regards
Frank Kabel
Frankfurt, Germany

"Spunky" schrieb im Newsbeitrag
...
My exact formula is listed below in my first post,
=SUMIF(msdatabase,Container,CurrTotalQTY) . The result does not
include the
first record that meets the criteria "Container", it does total
the
qty
(currtotalqty) of the ZCSU2333593 container without the first
record.
In
this example, the record not included is in row 2, however, if I
sort
it
differently and this container falls in the middle or the end of
the
database, it still skips the first record in the database that
has
ZCSU2333593 as it's container name. Below is a sample of records
in
the
database with the header row.
Container Job# Line DESCRIPTION Q'TY/CTN CARTONS QTY Dollars
Charge
to Dept
ZCSU2333593 340245-1 PATHWAY 4s & 5s Bible Time(Take Home
) 4 473 $15.84 2641.5404
ZCSU2333593 370245-1 BJU 4s & 5s Bible Time(Take Home
) 4 567 $18.99 2641.5404
ZCSU2333593 340325-1 PATHWAY Primary Bible Ways 6 1050 $35.16
2641.5404
ZCSU2333593 370325-1 BJU Primary Bible Ways 9 1733 $58.03
2641.5404
ZCSU2333593 370425 ACCENT Middler Bible Promises 28 5600 $187.53
2380.5008
ZCSU2333593 310225 BIL Early Elementary Bible
Beginnings 140 21000 $703.24 2080.5008
ZCSU2333593 310875 BIL Comprehensive Bible Study Large
Print 336 26880 $900.14 2080.5008
TRIU5470329 350875-5 COGBF Adult Teacher's Guide 9 720 $24.11
2480.5008
TRIU5470329 350875-7 COGBF Adult Teacher's Guide 17 1360 $45.54
2480.5008




"Frank Kabel" wrote:

Hi
as posted: Provide us with the name definition formulas and/or
your
EXACT formula

--
Regards
Frank Kabel
Frankfurt, Germany

"Spunky" schrieb im
Newsbeitrag
...
I'm doing a sumif formula and my answer does not sum the
first
row in
the
database range that matches this criteria. I can change the
sort
of
the
database but the answer still does not include the very first
record
that is
referenced in my criteria. Why not?
"Peo Sjoblom" wrote:

Is that an answer to a post? If so include the post in
question

Regards,

Peo Sjoblom

"Spunky" wrote:

=SUMIF(msdatabase,Container,CurrTotalQTY)

My answer is not including the first row in the database
range
that matches
this criteria. It seems this is regardless of how I sort
it.