G
gary davis
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/tutorial...bed-714745a97b3a/silverlight-wpf-xaml-an.aspx
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/tutorial...bed-714745a97b3a/silverlight-wpf-xaml-an.aspx