calculations

  • Thread starter Thread starter george
  • Start date Start date
G

george

Wondering how I go about something like this:

I have a spreadsheet that has a daily accumulation of cash receipts with
many
different account numbers.

I want to have a report that will use this spreadsheet to
list all the account numbers then total up the cash receipt for the month.

How can I go about doing this?

Spreadsheet is laid out like this.

Date Name Cash Receipt Account Number


The account number can appear many times. So in my report I want to
show the account number once and a total for the cash receipts. Account
numbers could change from month to month.

Thanks,
George
 
George,

It sounds like a Pivot Table Report is right for you. Check out Data/Pivot
Table and Pivot Chart Report. As soon as you've mastered pivot tables you
will have discovered the real power and real ROI of Excel!

Ross
 
Back
Top