Thread: if and sumif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] KurtABeard@gmail.com is offline
external usenet poster
 
Posts: 2
Default if and sumif

I am putting together a budget spreadsheet and would like to have one
expense tracking spreadsheet.
In my budget sheet I want to run check two pieces of data in the
expense sheet. I want to check the month and the category of an expense
then pull it over into the budget sheet. I am currently using the sumif
function to call by category but I also want to check the month. My
goal is to have a budget tab for each month and one expense tab in
order to do this I need to get the sum of the information based on the
month column and the category column. Ie I need all the food expenses
for July.

Thanks for the help,