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.