Finding dates within a date range
 

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 just can't work out how
to specify that only dates within a certain period should be chosen.

Can any body help me work this out?

Please accept my apologies for posting this question in two groups. I only
found the excel worksheet functions group after I had posted in the excel
general questions group.

Thanks in advance.

Marcus

On Mon, 4 Apr 2005 16:51:03 -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 just can't work out how
to specify that only dates within a certain period should be chosen.

Can any body help me work this out?

Please accept my apologies for posting this question in two groups. I only
found the excel worksheet functions group after I had posted in the excel
general questions group.

Thanks in advance.

Marcus

See answer in .programming NG
--ron

=SUMIF(A1:A25,"1/3/04",B1:B25)-SUMIF(A1:A25,"1/6/04",B1:B25)

Vaya con Dios,
Chuck, CABGx3


"Marcus" wrote in message
...
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 just can't work out
how
to specify that only dates within a certain period should be chosen.

Can any body help me work this out?

Please accept my apologies for posting this question in two groups. I
only
found the excel worksheet functions group after I had posted in the excel
general questions group.

Thanks in advance.

Marcus