Create SumIf function for date parameters

's Computer Specifications

Can someone help me in creating a sumif function that will add all the dollar
amounts corresponding to only January's dates. I've tried to use the formula
below with no success.

Date Dollar
January 1, 2007 40 =SUMIF(A2:A10,"">=(MONTH(1)),Dollar)
January 5, 2007 55
January 9, 2007 56
February 2, 2007 40
February 4, 2007 12
February 14, 2007 78
March 1, 2007 62
March 15, 2007 35
March 6, 2007 45

--
Miroshak

's Computer Specifications

Try:
=Sumproduct(--(Month(A2:A10)=1), B2:B10)

"Miroshak" wrote:

> Can someone help me in creating a sumif function that will add all the dollar
> amounts corresponding to only January's dates. I've tried to use the formula
> below with no success.
>
> Date Dollar
> January 1, 2007 40 =SUMIF(A2:A10,"">=(MONTH(1)),Dollar)
> January 5, 2007 55
> January 9, 2007 56
> February 2, 2007 40
> February 4, 2007 12
> February 14, 2007 78
> March 1, 2007 62
> March 15, 2007 35
> March 6, 2007 45
>
>
> --
> Miroshak

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUMIF within date range as a function of today()'s date	=?Utf-8?B?aXJ2aW5lNzk=?=	Microsoft Excel Worksheet Functions	8	6th Aug 2006 05:55 PM
create function with passing parameters	=?Utf-8?B?REFTbWFuaWEgQ29vbA==?=	Microsoft Excel Programming	6	6th Jan 2006 03:56 PM
How can I use a date as part of the criteria in a sumif function..	=?Utf-8?B?cGxpbmRzYXk=?=	Microsoft Excel Worksheet Functions	1	15th Oct 2004 10:53 PM
SUMIF function not working with Date	=?Utf-8?B?U0w=?=	Microsoft Excel Worksheet Functions	3	3rd Aug 2004 01:04 PM
Re: SUMIF function based on a date	Myrna Larson	Microsoft Excel Worksheet Functions	0	25th Sep 2003 03:51 AM