function
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! |
function
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 "glpeters" wrote in message ... 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! |
All times are GMT +1. The time now is 03:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com