Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with excel function
I am starting a spreadsheet to keep track of income and expenses and
as of now i have Columns: Date, Item, Type, Payee, Amount, and Balance. I want to try and keep track of how much i spend on each "type" so for example the Type column is in column C and the amount column is in column E, what I want to do is have a seperate chart and basically have a number pop out sorting the amounts of each type. So lets say the type I want is "Income" what formula would I put if i want to add all the amounts in column E that have the word "income" in the same row in column C, if that makes sense Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with excel function
Look in the help index for SUMIF
-- Don Guillett Microsoft MVP Excel SalesAid Software wrote in message ... I am starting a spreadsheet to keep track of income and expenses and as of now i have Columns: Date, Item, Type, Payee, Amount, and Balance. I want to try and keep track of how much i spend on each "type" so for example the Type column is in column C and the amount column is in column E, what I want to do is have a seperate chart and basically have a number pop out sorting the amounts of each type. So lets say the type I want is "Income" what formula would I put if i want to add all the amounts in column E that have the word "income" in the same row in column C, if that makes sense Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help to build a Look Up Function or What Ever Function Excel 2002 | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
challenge! javascript function into excel function | Excel Worksheet Functions | |||
Excel Workday Function with another function | Excel Discussion (Misc queries) | |||
Can you nest a MID function within a IF function in Excel | Excel Worksheet Functions |