Hi there... just found this site and it has been very helpful. I am hoping someone can help me out. I am trying to create a monthly profitability statement. In one tab of my workbook would be a list of expenses (Expense Input tab) with the following column headers:
Column A - Date
Column B - Classification (type of expense i.e. Advertising, Cost of Goods Sold, etc)
Column C- Dollar Amount
Column D - Vendor
On my profitability statement, each column is a different month. I am trying to write a formula where it will basically say "if it is an Advertising expense and it falls between 1/1/13 and 1/31/13, show the dollar amount." I put in two entries for Advertising in different months and started out by using this formula:
=SUMIFS('Expense Input'!$C$3:$C$1000,'Expense Input'!$B$3:$B$1000,"Advertising")
This obviously brought back both dollar amounts. I then tried to add in a second date range condition and NOTHING I tried worked. Can anyone see what I am doing wrong? Thanks again!
Bookmarks