not the slightest idea how this is done.

[smm3]

i have looked on this site and can't find anything that works.

I have Bingo winners listed by month. I need to combine all the winners and add their amounts of winnings so I can have a running list for the year.

Alanis, Renee $22.00 $22.00
Alves, Susan $32.00 $45.00 $77.00
Arabie, Patty $25.00 $25.00
Arbanas, Karen $69.00 $67.00 $136.00
Aust, Astrid $1,184.00 $28.00 $23.00 $25.00 $1,342.00
Benabidez, Lucy $138.00 $25.00 $163.00
Black, Kim $16.00 $25.00 $41.00

I have hundreds of winners every month, sometimes same winner some different winners.


Gosh, I hope this makes sense.
Vickie

 

[jfish1288]

This sounds like a very doable task but it isn't very clear.

Can you post a small sample of the original list and what the combined list would be for that sample. Be sure to indicate separate column if they are there.

 

[sheetspread]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Name	January	February	March	April	May	June	July	August	September	October	November	December	2011
2	Alanis, Renee	$22.00	$22.00											$44.00
3	Alves, Susan	$32.00	$45.00	$77.00										$154.00
4	Arabie, Patty	$25.00	$25.00											$50.00
5	Arbanas, Karen	$69.00	$67.00	$136.00										$272.00
6	Aust, Astrid	$1,184.00	$28.00	$23.00	$25.00	$1,342.00								$2,602.00
7	Benabidez, Lucy	$138.00	$25.00	$163.00										$326.00
8	Black, Kim	$16.00	$25.00	$41.00										$82.00
9		$1,486.00	$237.00	$440.00	$25.00	$1,342.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$3,530.00
Sheet1

If there is only one game per month then this is the exact format, which can easily be changed for weekly games or other periods.