function

[glpeters]

Am preparing a (calendar) budget using Excel worksheet. In one column I have
listed all the monetary values of the particular budget items, on the day
that item will be spent. In 2nd column I have the text identifier of the
expense item. Several of the identifiers are the same, just appearing on
different days of the month, in the column. Question, how can I query one
particular item (identifier) and have it give me the total of all the values
for that particular item? Pretty new to this, so bear with me, thanx!

 

[Mike Middleton]

glpeters -

I suggest arranging your data on the worksheet in standard database form, as
it appears you have already done, and then using Excel's Pivot Table feature
to summarize, e.g., to get a total ...

And, if you do, you'll be able to do many other types of analyses and answer
other questions.

For more info, use Google or other search engine to search for "excel pivot
table" (without the quotes).

- Mike
http://www.MikeMiddleton.com



Am preparing a (calendar) budget using Excel worksheet. In one column I have
listed all the monetary values of the particular budget items, on the day
that item will be spent. In 2nd column I have the text identifier of the
expense item. Several of the identifiers are the same, just appearing on
different days of the month, in the column. Question, how can I query one
particular item (identifier) and have it give me the total of all the values
for that particular item? Pretty new to this, so bear with me, thanx!