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.