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.