View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
gabrielinlompoc
 
Posts: n/a
Default 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...!?!?!?!?!?!?