Sort and report Question

[kohlhammond]

1	monday
amount	label
10	gas
20	lunch
35	food
78	insurance

<tbody>
</tbody>

Hello I am brand new to the forum and have a question I don't know anything about excel except that I know it is more powerful than what I am using it for. I am creating a budget and in this budget I have a group of cells that is 2 columns by 7 rows, it is used to represent a single days expenditures with the first row expressing the day I.E. (1 Monday) the next row separates the group of cells into a table with the first column being amount and the second column being label. Now the rest of the group of cells gives data. I.E. (10.00 gas, 20.00 lunch) I would like a formula that will take as its argument this table and tell me how many lunches there were with the total for every lunch that appeared. basically I have a table for the whole month and I want to sort through that table, and keep the data cells "amount" and "label" together and have them sorted by label. I would like this formula to populate a table in a new sheet with label specific data, I.E. I have a sheet labeled auto that will organize all related data "gas, insurance, oil change, ect." The formula must be able to take multiple label cells and sort them into tables in another sheet. something like sort((label column: "gas","insurance","oil")To auto!)

Any help from a excel guru would be nice thanks

 

[Smitty]

Welcome to the Board!

You'll be much better off entering all of your transactions sequentially, like:

Date | Amount | Label

Then you can use a Pivot Table to summarize the data however you want. If you have Excel 2010+ you can use a Slicer on the Label field to quickly summarize it by any category.

The way you have it the records that you entered are technically orphans since there's no way to tie them to the day, so you'll be hard pressed to summarize anything.

HTH,