PDA

View Full Version : collecting particular type of fileds



sureshprabhu
02-06-2007, 05:10 AM
Hi!
I want to collect some common fields in my list. In detail, Lets think that I have one list of daily expenses, from that list I want to collect a particular type of expenses. How can I do this? Help me!
Thanks in advance,
SureshP

Charlize
02-06-2007, 05:17 AM
maybe autofilter ?

Charlize

ps. a bit of data to work with would be helpfull

sureshprabhu
02-06-2007, 05:26 AM
Sorry Charlize! I didnt get you!

Norie
02-06-2007, 11:38 AM
What do you mean by 'collect'?

Perhaps SUMIF or COUNTIF?

Charlize
02-06-2007, 04:36 PM
maybe autofilter ?

Charlize

ps. a bit of data to work with would be helpfull
Which part you didn't get ?
Let's say you have several columns (date,description,categorie,amount)
For categories you have : home, car, gas, water, electricity ...
With autofilter you can filter on categorie and/or any of the 4 columns.

Charlize