both enddate and start date are meant to be cell references

=sumif(A:A,"<="&M2,C:C)-Sumif(A:A,"<"&M1,C:C)

where M2 holds the end date and M1 holds the start date (for example)

--
Regards,
Tom Ogilvy


"John" wrote in message
...
Thanks for the replies.

Tom I assume your "enddate" could be a cell value...

Thanks again.

"Tom Ogilvy" wrote:

=sumif(A:A,"<="&EndDate,C:C)-Sumif(A:A,"<"&StartDate,C:C)

would be one way.

--
Regards,
Tom Ogilvy


"John" wrote in message
...
If Column A is dates for this year (1-1-05, 1-2-05,...) and column C
is
values corresponding to those dates. How can I sum this months values
only
(so that next month it will do the same without changing my sum
range).

If it helps, I have the start and end day of the month in two cells...

Thanks for the help.

John