I currently have spreadsheets on which things appear only if certain criteria
are met (call it €œOrdersheet€�). I know this uses the If/Concatenate function.
most of it is working properly, but I recently was asked to add a section to
it, and I'm not sure how to make it work.

On another spreadsheet (same workbook) I have a sheet with prizes (well
call it €œprizesheet€�). each of the employee's put down what they wanted if
they met certain incentive goals. they were given a list with slots ranging
1-14. Each person was told to order desired prizes in these slots. Some
people put multiples of the same items on the sheet, and in addition the
number they wanted to buy, (also some items are only available in certain
slots).
I need it to appear on the order form with only the totals for each type,
not the goal at which they were achieved.

for example if a person choose on the Prizesheets:
level prize
1 watch 1
1 or bracelet 0
2 notebook 1
3 mug 1
4 watch 1
5 mug 1
and in addition chose to purchase
watch 2
notebook 1

then I need it to show on my Ordersheet as
watch 4
notebook 2
mug 2


in addition, I need it to keep updating based on the number of goals they
meet,
so that if they meet only 3 goals then only the first 3, plus purchases is
totaled, but if they meet 5 goals, then those additional goals get added in
at that time. (hope that makes sense). please help, or point me in the right
direction, if you can. thanks