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.
|