Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm trying to do something simple (my opinion) but I'm just not sure how to
do it and the documentation on the functions isn't exactly intuitive or well done. I have a spreasheet of expenditures. Each row consists of date, merchant, type (golf, groceries, medical, gas, etc) and amount. I want to show elsewhere the total of my expenditures by category. This will require a function will will add column D to the "Gas Expenditures" cell when the value in column C equals "gas". I'd then do the same with other types of expenditures. After tackling that, I'll move to the next issue of maintaining those totals across worksheets (each worksheet representing a month of the year). If anyone is aware of free unencumbered templates I'd gladly not reinvent the "wheel". Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I can't figure out how to add values based on font color. | Excel Discussion (Misc queries) | |||
list two columnar values based on conditional formating (text color) | Excel Worksheet Functions | |||
adding values based on criteria | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
If I have X,Y data how do I sum the Y values using a set of bins based on x values | Excel Worksheet Functions |