I am trying to create a spreadsheet to help with a silent auction. What I
would like to do is enter the winners bidder number as well as the winning
bid in 2 columns corresponding to the item number. I originally thought of
creating an individual work sheet for each item, then just entering the
bidder number and winning bid in to each sheet and having the formula search
through all the sheets.

Either way, I need to then search through the information I have put in so
that I can easily gather the total amount a bidder has spent, as well as the
item numbers that they have won. If anyone can help, it would be greatly
appreciated. If it would be easier to do it all on one sheet, or making
separate sheets, whatever you can help with would be great. Thank you in
advance.

Ken,

take a look at SUMIF for the total spend. You may need an array formula to
collect the item numbers, but you don't really give enough clear information
to work with here (imho).



"Ken P" <Ken wrote in message
...
I am trying to create a spreadsheet to help with a silent auction. What I
would like to do is enter the winners bidder number as well as the winning
bid in 2 columns corresponding to the item number. I originally thought of
creating an individual work sheet for each item, then just entering the
bidder number and winning bid in to each sheet and having the formula
search
through all the sheets.

Either way, I need to then search through the information I have put in so
that I can easily gather the total amount a bidder has spent, as well as
the
item numbers that they have won. If anyone can help, it would be greatly
appreciated. If it would be easier to do it all on one sheet, or making
separate sheets, whatever you can help with would be great. Thank you in
advance.