Sumif by date

[Hozz]

Hi,

I'm attempting to use the sumif command depending on a date in column D. D is formatted as a date (mmm-yy).

Column V contains the numbers i need to add.

If the dates in D is january and the year is 06, then i want the corresponding numbers in column V added.

What would the formula for this be?

 

[ADAMC]

Hi

I put todays date in D1 and put 12 in V1

In any column i put this:

=SUM(D1+V1)

It returned 08/08/07

Hope this helps

 

[ravishankar]

Hi
A1=sumif(D1:D100,"jan-06",V1:V100)
Ravi

 

[Hozz]

No. You misunderstand.

I have a column of random numbers in V.

If the date in column D is showing as january 2006 then i want the corresponding numbers in column V to be added together.

 

[SteveO59L]

=SUMIF(H8:H97,"<"&"01-feb-07",I8:I97)-SUMIF(H8:H97,"<"&"01-jan-07",I8:I97)

 

[venkat1926]

sumif is normally used to add data in one column under some crietria.;
if the adding depends upon value in another column better use sumproduct.

see the sample sheet below
see formula in B12 . modify formula to suit you.

Book1
	A	B	C	D
1	1-Jul	10
2	2-Jul	4
3	3-Jul	6
4	4-Jul	7
5	1-Jul	6
6	2-Jul	8
7	1-Jul	9
8	2-Jul	5
9	1-Jul	7
10
11
12		32
Sheet1

 

[ADAMC]

So....you have a date in D1, D2 D3 etc....
and you want them adding to V1, V2, V3??


My original post would work:

=SUM(D1+V1) fill this down whichever column you are going to have the formula would then produce
=SUM(D+V2) etc etc

 

[stanleydgromjr]

Hozz,

Try this (you may have to adjust the ranges):
=SUMPRODUCT(--(TEXT($D$2:$D$1000,"mmm-yy")="Jan-06"),$V$2:$V$1000)

Have a great day,
Stan

 

[Stormseed]

Stan, why do you feel the need to coerce the date into text?

I am asking you this because, Venkat provided an example above and it works perfect without coercing the date.