Help !!! With name and amount spread sheet

T

txdiva

I am very new to excel. My church is having a banquet to celebrate its 50th
anniversary this November. We need a spreadsheet that will allow me to track
names, ticket numbers, and total the funds as the money comes in to the
office.

Any help will be appreciated .
 
D

Dave F

The simplest way to do this would be to create a spreadsheet with three
columns: Name, Ticket number, and Funds

Then you could just sum the Funds column using the SUM function. If the
Funds column is C, then something like =SUM(C2:C100) would give you your
answer.

Of course, this is a relatively simple set up. If your analysis needs are
more complex post back and someone can help you set up something more robust.

Dave
 
Top