Take a look at the sumproduct formula...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

This should work for you.
--
HTH...

Jim Thomlinson


"John" wrote:

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