Hi:
I need to find a specific date range i.e. 06/01/06 - 06/30/06, then add the
sum of the values in another column. I tried the if formula and then the
date value but I got a #value error. Here's where I'm at: If the date range
H2 to H522 is in the 06/01/06 to 06/30/06 range, then add the figures in
cells I2 to I522.
=if(H2:H522,"06/01/06:06/30/06",I2:I522) Can you help?
--
Marg R.

=SUMPRODUCT(--(H2:H522=--"6/1/2006"),--(H2:H522<=--"6/30/2006"),I2:I522)


"Marg" wrote:

Hi:
I need to find a specific date range i.e. 06/01/06 - 06/30/06, then add the
sum of the values in another column. I tried the if formula and then the
date value but I got a #value error. Here's where I'm at: If the date range
H2 to H522 is in the 06/01/06 to 06/30/06 range, then add the figures in
cells I2 to I522.
=if(H2:H522,"06/01/06:06/30/06",I2:I522) Can you help?
--
Marg R.

If you're always summing for a whole calendar month then perhaps this

=SUMPRODUCT(--(H2:H522-DAY(H2:H522)+1=J2),I2:I522)

where J2 contains the first day of the month in question, e.g. 1st June 2006

"Teethless mama" wrote:

=SUMPRODUCT(--(H2:H522=--"6/1/2006"),--(H2:H522<=--"6/30/2006"),I2:I522)


"Marg" wrote:

Hi:
I need to find a specific date range i.e. 06/01/06 - 06/30/06, then add the
sum of the values in another column. I tried the if formula and then the
date value but I got a #value error. Here's where I'm at: If the date range
H2 to H522 is in the 06/01/06 to 06/30/06 range, then add the figures in
cells I2 to I522.
=if(H2:H522,"06/01/06:06/30/06",I2:I522) Can you help?
--
Marg R.