| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumifs with data and dates - I can not figure out the dates
Assuming you are using xl-2007
=SUMIFS(C:C,B:B,"="&DATE(2010,1,1),B:B,"<="&DATE( 2010,12,31)) "gary davis" wrote: 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 . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIFS formula using dates and text as criteria | Excel Discussion (Misc queries) | |||
| sumifs between 2 specific dates entered. | Excel Worksheet Functions | |||
| SUMIFS and dates | Excel Worksheet Functions | |||
| sumifs, sumif with dates | Excel Worksheet Functions | |||
| SUMIFS with dates | Excel Worksheet Functions | |||
Threaded Mode
