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