Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |