|
sumif
=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. |
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. |
Hi
you may post the name definition for your three defined names (or post the exact formula) -- Regards Frank Kabel Frankfurt, Germany "Spunky" schrieb im Newsbeitrag ... =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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
| All times are GMT +1. The time now is 06:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com