I have a column in a spreadsheet that consists of dates in dd/mm/yyyy format.
I'm trying to write a formula that looks at the dates by row in the colum
and if the date falls within a certain range (eg from 01/04/2004 to
01/06/2004) then I want to sum the values in another column. I've worked out
that I need to use the sumif function but I can't work out how to analyse the
date range.

How do I tell the function to look at the dates in the column and if they
are within a certain range to sum the values in another column. As I said,
I'm pretty sure I need to use the sumif function - I kust can't work out how
to specify that only dates within a certain periodshould be chosen.

Can any body help me work this out?

Thanks in advance.

Marcus

On Mon, 4 Apr 2005 16:45:07 -0700, Marcus
wrote:

I have a column in a spreadsheet that consists of dates in dd/mm/yyyy format.
I'm trying to write a formula that looks at the dates by row in the colum
and if the date falls within a certain range (eg from 01/04/2004 to
01/06/2004) then I want to sum the values in another column. I've worked out
that I need to use the sumif function but I can't work out how to analyse the
date range.

How do I tell the function to look at the dates in the column and if they
are within a certain range to sum the values in another column. As I said,
I'm pretty sure I need to use the sumif function - I kust can't work out how
to specify that only dates within a certain periodshould be chosen.

Can any body help me work this out?

Thanks in advance.

Marcus

In general:

=SUMIF(date_rng,"="&cell_ref_start_date,rng_to_su m) -
SUMIF(date_rng,""&cell_ref_end_date,rng_to_sum)

date_rng: range containing the dates
rng_to_sum: range containing values to be summed
cell_ref_start_date: A cell containing the beginning date of the range to
sum
cell_ref_end_date: A cell containing the ending date.


--ron