#1   Report Post  
Spunky
 
Posts: n/a
Default 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.
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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.

  #3   Report Post  
Frank Kabel
 
Posts: n/a
Default

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.


  #4   Report Post  
Spunky
 
Posts: n/a
Default

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.

  #5   Report Post  
Frank Kabel
 
Posts: n/a
Default

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.




  #6   Report Post  
Spunky
 
Posts: n/a
Default

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.



  #7   Report Post  
Frank Kabel
 
Posts: n/a
Default

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.




  #8   Report Post  
Spunky
 
Posts: n/a
Default

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.




  #9   Report Post  
Frank Kabel
 
Posts: n/a
Default

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.





  #10   Report Post  
Spunky
 
Posts: n/a
Default

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.






Reply
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
Sumif or if statements-Help! ber_harris Excel Discussion (Misc queries) 5 December 1st 04 11:57 PM


All times are GMT +1. The time now is 12:56 PM.

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

About Us

"It's about Microsoft Excel"