Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing based on various critiera
I have been using a formula provided by Bob Phillips here to determine who
would the total number of t-shirts by size based on monies raised. In the past, it has been the same amount of monies for everyone. Now, we are using one amount for adults and one amount for kids. The old fomula was: =SUMPRODUCT(--($C$6:$C$20=F24),--($F$6:$F$2099)) Can someone tell me how to change the formula where the goal is $50 for kids and $100 for adults? Thanks in advance and I am using an old username when I need a quick answer. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing based on various critiera
What determines who is an adult and who is a kid? What is in the cells in
the formula you submitted? We have no idea what your original question was and what your formula means. Mind readers, we are not. Tyro "NeedHelpFast" wrote in message ... I have been using a formula provided by Bob Phillips here to determine who would the total number of t-shirts by size based on monies raised. In the past, it has been the same amount of monies for everyone. Now, we are using one amount for adults and one amount for kids. The old fomula was: =SUMPRODUCT(--($C$6:$C$20=F24),--($F$6:$F$2099)) Can someone tell me how to change the formula where the goal is $50 for kids and $100 for adults? Thanks in advance and I am using an old username when I need a quick answer. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing based on various critiera
Good point, Tyro. Sorry
I have a formula that determines if they get a shirt based on the dollar amount (currently $100). If they do, my formula will result in "Y". I have table set up as shown Col A = Shirt size (ex small) Col B = =SUMPRODUCT(--($C$6:$C$20=F24),--($F$6:$F$2099)) to get the total of each size. Now, I have the two critiera, one for adult, one for youth. I know I may need to add at col. that indicates adult or youth. Which I don't have a problem with other than I don't know how to write the formula. Thanks "Tyro" wrote: What determines who is an adult and who is a kid? What is in the cells in the formula you submitted? We have no idea what your original question was and what your formula means. Mind readers, we are not. Tyro "NeedHelpFast" wrote in message ... I have been using a formula provided by Bob Phillips here to determine who would the total number of t-shirts by size based on monies raised. In the past, it has been the same amount of monies for everyone. Now, we are using one amount for adults and one amount for kids. The old fomula was: =SUMPRODUCT(--($C$6:$C$20=F24),--($F$6:$F$2099)) Can someone tell me how to change the formula where the goal is $50 for kids and $100 for adults? Thanks in advance and I am using an old username when I need a quick answer. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing based on various critiera
What is in cells C6:C20 and what does it mean? What is in Cell F24 and what
does it mean? What is in cells F6:F20 and what does it mean? What is the meaning of 99? You are making this difficult. You know what your data means. I do not. Tyro "NeedHelpFast" wrote in message ... Good point, Tyro. Sorry I have a formula that determines if they get a shirt based on the dollar amount (currently $100). If they do, my formula will result in "Y". I have table set up as shown Col A = Shirt size (ex small) Col B = =SUMPRODUCT(--($C$6:$C$20=F24),--($F$6:$F$2099)) to get the total of each size. Now, I have the two critiera, one for adult, one for youth. I know I may need to add at col. that indicates adult or youth. Which I don't have a problem with other than I don't know how to write the formula. Thanks "Tyro" wrote: What determines who is an adult and who is a kid? What is in the cells in the formula you submitted? We have no idea what your original question was and what your formula means. Mind readers, we are not. Tyro "NeedHelpFast" wrote in message ... I have been using a formula provided by Bob Phillips here to determine who would the total number of t-shirts by size based on monies raised. In the past, it has been the same amount of monies for everyone. Now, we are using one amount for adults and one amount for kids. The old fomula was: =SUMPRODUCT(--($C$6:$C$20=F24),--($F$6:$F$2099)) Can someone tell me how to change the formula where the goal is $50 for kids and $100 for adults? Thanks in advance and I am using an old username when I need a quick answer. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing based on various critiera
C6:20 = Shirt sizes (determined from a lookup table from a download)
F24 €“ is the start of a shirt size table F25 would be the next shirt size F6:20 €“ is the total each person raised 99 is to determine who raised at least $100. Col a Col B Col C Col D Name Size Total Raised Get a shirt 1 Mary Smith S $100 Y 2 Joe Jones L $20 3 Billy Jones YL $50 Y Mary gets a shirt because she raised $100 and she is an adult. Joe does not get a shirt because he is an adult and he is below $100. Billy gets a shirt because he is a youth and he raised $50. I need to total each shirt size based on adults reaching $100 and youth reaching $50. I can add a col to show who is an adult and who is a youth if it would make the formula easier. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing based on various critiera
You're getting closer. But what tells me Mary Smith is an adult and the Joe
Jones is an adult and that Billy Jones is a youth? What I'm saying is, all detail is required to generate a solution. Tyro "NeedHelpFast" wrote in message ... C6:20 = Shirt sizes (determined from a lookup table from a download) F24 - is the start of a shirt size table F25 would be the next shirt size F6:20 - is the total each person raised 99 is to determine who raised at least $100. Col a Col B Col C Col D Name Size Total Raised Get a shirt 1 Mary Smith S $100 Y 2 Joe Jones L $20 3 Billy Jones YL $50 Y Mary gets a shirt because she raised $100 and she is an adult. Joe does not get a shirt because he is an adult and he is below $100. Billy gets a shirt because he is a youth and he raised $50. I need to total each shirt size based on adults reaching $100 and youth reaching $50. I can add a col to show who is an adult and who is a youth if it would make the formula easier. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing based on various critiera
Right now, nothing. But as I said, I can add a column that would have A for
adult and Y for youth. I would make it Col B and move everything else over 1 col. "Tyro" wrote: You're getting closer. But what tells me Mary Smith is an adult and the Joe Jones is an adult and that Billy Jones is a youth? What I'm saying is, all detail is required to generate a solution. Tyro "NeedHelpFast" wrote in message ... C6:20 = Shirt sizes (determined from a lookup table from a download) F24 - is the start of a shirt size table F25 would be the next shirt size F6:20 - is the total each person raised 99 is to determine who raised at least $100. Col a Col B Col C Col D Name Size Total Raised Get a shirt 1 Mary Smith S $100 Y 2 Joe Jones L $20 3 Billy Jones YL $50 Y Mary gets a shirt because she raised $100 and she is an adult. Joe does not get a shirt because he is an adult and he is below $100. Billy gets a shirt because he is a youth and he raised $50. I need to total each shirt size based on adults reaching $100 and youth reaching $50. I can add a col to show who is an adult and who is a youth if it would make the formula easier. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing based on various critiera
You want your calculation to be include the factor of being an adult or
child, as I understand it. Therefore, the information must be provided to the formula. The formula does not know the people involved. Tyro "NeedHelpFast" wrote in message ... Right now, nothing. But as I said, I can add a column that would have A for adult and Y for youth. I would make it Col B and move everything else over 1 col. "Tyro" wrote: You're getting closer. But what tells me Mary Smith is an adult and the Joe Jones is an adult and that Billy Jones is a youth? What I'm saying is, all detail is required to generate a solution. Tyro "NeedHelpFast" wrote in message ... C6:20 = Shirt sizes (determined from a lookup table from a download) F24 - is the start of a shirt size table F25 would be the next shirt size F6:20 - is the total each person raised 99 is to determine who raised at least $100. Col a Col B Col C Col D Name Size Total Raised Get a shirt 1 Mary Smith S $100 Y 2 Joe Jones L $20 3 Billy Jones YL $50 Y Mary gets a shirt because she raised $100 and she is an adult. Joe does not get a shirt because he is an adult and he is below $100. Billy gets a shirt because he is a youth and he raised $50. I need to total each shirt size based on adults reaching $100 and youth reaching $50. I can add a col to show who is an adult and who is a youth if it would make the formula easier. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing based on various critiera
NeedHelpFast -
I suggest you set up your data in a standard flat-file database arrangement. Then it will be easy to answer this question (and others) using a pivot table. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "NeedHelpFast" wrote in message ... I have been using a formula provided by Bob Phillips here to determine who would the total number of t-shirts by size based on monies raised. In the past, it has been the same amount of monies for everyone. Now, we are using one amount for adults and one amount for kids. The old fomula was: =SUMPRODUCT(--($C$6:$C$20=F24),--($F$6:$F$2099)) Can someone tell me how to change the formula where the goal is $50 for kids and $100 for adults? Thanks in advance and I am using an old username when I need a quick answer. |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing based on various critiera
I don't think the OP has any clue about what a flat-file is let alone a
database arrangement. Tyro "Mike Middleton" wrote in message ... NeedHelpFast - I suggest you set up your data in a standard flat-file database arrangement. Then it will be easy to answer this question (and others) using a pivot table. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "NeedHelpFast" wrote in message ... I have been using a formula provided by Bob Phillips here to determine who would the total number of t-shirts by size based on monies raised. In the past, it has been the same amount of monies for everyone. Now, we are using one amount for adults and one amount for kids. The old fomula was: =SUMPRODUCT(--($C$6:$C$20=F24),--($F$6:$F$2099)) Can someone tell me how to change the formula where the goal is $50 for kids and $100 for adults? Thanks in advance and I am using an old username when I need a quick answer. |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing based on various critiera
Tyro,
I know full well what a flat file is and I know what a database arrangement is. I appreciate you trying to help, but you don't have to act like a jerk because I couldn't make my problem clear to you. No more replies are needed or wanted from you. Thanks anyway. "Tyro" wrote: I don't think the OP has any clue about what a flat-file is let alone a database arrangement. Tyro "Mike Middleton" wrote in message ... NeedHelpFast - I suggest you set up your data in a standard flat-file database arrangement. Then it will be easy to answer this question (and others) using a pivot table. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "NeedHelpFast" wrote in message ... I have been using a formula provided by Bob Phillips here to determine who would the total number of t-shirts by size based on monies raised. In the past, it has been the same amount of monies for everyone. Now, we are using one amount for adults and one amount for kids. The old fomula was: =SUMPRODUCT(--($C$6:$C$20=F24),--($F$6:$F$2099)) Can someone tell me how to change the formula where the goal is $50 for kids and $100 for adults? Thanks in advance and I am using an old username when I need a quick answer. |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing based on various critiera
If you can send a copy of your file to me I'll see what I can come up with.
If you want to do that I'm at: xl can help at comcast period net Remove "can" and change the obvious. -- Biff Microsoft Excel MVP "NeedHelpFast" wrote in message ... Tyro, I know full well what a flat file is and I know what a database arrangement is. I appreciate you trying to help, but you don't have to act like a jerk because I couldn't make my problem clear to you. No more replies are needed or wanted from you. Thanks anyway. "Tyro" wrote: I don't think the OP has any clue about what a flat-file is let alone a database arrangement. Tyro "Mike Middleton" wrote in message ... NeedHelpFast - I suggest you set up your data in a standard flat-file database arrangement. Then it will be easy to answer this question (and others) using a pivot table. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "NeedHelpFast" wrote in message ... I have been using a formula provided by Bob Phillips here to determine who would the total number of t-shirts by size based on monies raised. In the past, it has been the same amount of monies for everyone. Now, we are using one amount for adults and one amount for kids. The old fomula was: =SUMPRODUCT(--($C$6:$C$20=F24),--($F$6:$F$2099)) Can someone tell me how to change the formula where the goal is $50 for kids and $100 for adults? Thanks in advance and I am using an old username when I need a quick answer. |
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing based on various critiera
Well, you couldn't seem to state a simple requirement. Don't blame me. You
needed several prompts to even get you to the point where you could begin to express your needs. Thinking is required before attempting to solve a problem. I didn't make this requirement. If you can't think clearly and express yourself, then you will always have this problem. Don't blame me. Take remedial steps if you want to help yourself. I'm no jerk, BTW. Tyro "NeedHelpFast" wrote in message ... Tyro, I know full well what a flat file is and I know what a database arrangement is. I appreciate you trying to help, but you don't have to act like a jerk because I couldn't make my problem clear to you. No more replies are needed or wanted from you. Thanks anyway. "Tyro" wrote: I don't think the OP has any clue about what a flat-file is let alone a database arrangement. Tyro "Mike Middleton" wrote in message ... NeedHelpFast - I suggest you set up your data in a standard flat-file database arrangement. Then it will be easy to answer this question (and others) using a pivot table. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "NeedHelpFast" wrote in message ... I have been using a formula provided by Bob Phillips here to determine who would the total number of t-shirts by size based on monies raised. In the past, it has been the same amount of monies for everyone. Now, we are using one amount for adults and one amount for kids. The old fomula was: =SUMPRODUCT(--($C$6:$C$20=F24),--($F$6:$F$2099)) Can someone tell me how to change the formula where the goal is $50 for kids and $100 for adults? Thanks in advance and I am using an old username when I need a quick answer. |
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing based on various critiera
I would suggest you add a column for Youth or Adult and not pull it directly
from shirt sizes. I'd be willing to bet there are some kids wearing adult sizes and some adults wearing youth sizes. -- HTH, Barb Reinhardt "NeedHelpFast" wrote: C6:20 = Shirt sizes (determined from a lookup table from a download) F24 €“ is the start of a shirt size table F25 would be the next shirt size F6:20 €“ is the total each person raised 99 is to determine who raised at least $100. Col a Col B Col C Col D Name Size Total Raised Get a shirt 1 Mary Smith S $100 Y 2 Joe Jones L $20 3 Billy Jones YL $50 Y Mary gets a shirt because she raised $100 and she is an adult. Joe does not get a shirt because he is an adult and he is below $100. Billy gets a shirt because he is a youth and he raised $50. I need to total each shirt size based on adults reaching $100 and youth reaching $50. I can add a col to show who is an adult and who is a youth if it would make the formula easier. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing based on criteria | Excel Worksheet Functions | |||
Summing based on 2 criteria | Excel Discussion (Misc queries) | |||
Summing every nth row value based upon variable | Excel Worksheet Functions | |||
Countif With Critiera | Excel Discussion (Misc queries) | |||
Summing based on format | New Users to Excel |