| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to add amount to a cell based on category and month
I have a list of expenxe categories and by month along the top. How can I
write the sumif function based on two criteria from drop-down list(one list is Expenses and the second list is the Months) and the third (Amount) cell would be where I input an amount to be added into the table: Expenses month amount Fuel JAN _______ Expenses JAN FEB MAR Trucks/Auto Fuel 348.23 Oils 35.99 Maintenance 298.33 Parts 59.21 DMV 745.87 -- so many functions...!?!?!?!?!?!? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif-add amount to another cell based on two criteria | Excel Discussion (Misc queries) | |||
| add to a cell on a list based on two criteria | New Users to Excel | |||
| cell to adjust in another workbook when cell changes | New Users to Excel | |||
| entering data to table | Excel Worksheet Functions | |||
| Month Year Date Format | Excel Worksheet Functions | |||
Threaded Mode
