Thread: Sumifs with data and dates - I can not figure out the dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gary davis gary davis is offline
external usenet poster
  
Posts: 1
Default Sumifs with data and dates - I can not figure out the dates

I need a formula for each item in col A that was added during 2010 only. the spreadsheet will have years of data.

A B
Expense Date Amount
Furniture 1/12/2010 $326.00
Inventory 1/15/2010 $250.00
Utilities 1/15/2010 $98.00
Rent 1/29/2010 $1,000.00
Rent 1/30/2010 $536.00

how can I Sumif with Critera in Col A and only for a specific year?

Gary



Submitted via EggHeadCafe - Software Developer Portal of Choice
Silverlight, WPF, XAML and InnerWorkings Coding Challenge
http://www.eggheadcafe.com/tutorials...f-xaml-an.aspx
Reply With QuoteReply With Quote