Totalling codes

[lorrdon]

Keeping an expense register in Excel V., using OS 10.3.9.
Entries are listed by date, and each one is coded, using 10
differentcode numbers.
Is there a way I can, weekly or monthly, get a total by each code
number ?

 

[Bob Greenblatt]

Keeping an expense register in Excel V., using OS 10.3.9.
Entries are listed by date, and each one is coded, using 10
differentcode numbers.
Is there a way I can, weekly or monthly, get a total by each code
number ?

Sure, Look at help for advanced filter. Should be pretty straight forward.

 

[JE McGimpsey]

Keeping an expense register in Excel V., using OS 10.3.9.
Entries are listed by date, and each one is coded, using 10
differentcode numbers.
Is there a way I can, weekly or monthly, get a total by each code
number ?

The slickest way would be to use a Pivot Table. You can group expenses
by day, week, month, quarter, etc., by code number.

For a good introduction to PTs, see Debra Dalgleish's article at

http://peltiertech.com/Excel/Pivots/pivotstart.htm

along with a number of good articles at her site:

http://www.contextures.com/tiptech.html

 

[Barry Wainwright [MVP]]

Keeping an expense register in Excel V., using OS 10.3.9.
Entries are listed by date, and each one is coded, using 10
differentcode numbers.
Is there a way I can, weekly or monthly, get a total by each code
number ?

Pivot Tables!

This sort of situation is precisely what they were invented for.

Unfortunately, ther eis not a lot of help in the excel online help to
explain them, so see here for an intro:

<http://www.cpearson.com/excel/pivots.htm>

 

[Barry Wainwright [MVP]]

The slickest way would be to use a Pivot Table. You can group expenses
by day, week, month, quarter, etc., by code number.

For a good introduction to PTs, see Debra Dalgleish's article at

http://peltiertech.com/Excel/Pivots/pivotstart.htm

along with a number of good articles at her site:

http://www.contextures.com/tiptech.html

Ah, there's another good site