Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a sheet setup to record my gas usage. The sheet is setup like so:
Week | gallons | price | vehicle | gallons | price | vehicle | and so on. 1 3.23 $3.50 Bike 3.45 $3.89 stang ....... 2 3.23 $3.50 Bike 3.45 $3.89 bike ....... 3 3.23 $3.50 stang 3.45 $3.89 bike ....... I want to look take all of the information at the end of the week and find out how much i spent on my car and how much i spent on my bike. I want to have a column on the right side of my sheet that will reference only the cells that are labled bike and add them up and put the total amount of money I spent in gas for my bike in that week. and the same for my mustang. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Simple lookup - or maybe not so simple - help! | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Make it more simple or intuitive to do simple things | Charts and Charting in Excel |