Thank you Bob...it works nicely!

"Bob Umlas" wrote:

> =SUM(A1:OFFSET(A1,0,0,1,mo.))
> assuming "mo." is the defined name, otherwise you can use the MONTH function
> of the cell containing the date (if the date is in Z1, for example,
> =SUM(A1:OFFSET(A1,0,0,1,MONTH(1)))
>
>
> "wilson@irco" <wilsonirco@discussions.microsoft.com> wrote in message
> news:631B6F77-6871-4C51-95AB-CD079C4901E3@microsoft.com...
> > In my budget comparison worksheet, I need to compare CYTD to PTYD totals
> and
> > would like to write conditional sumif that totals PYTD based on the month
> > (i.e, total A1:A1 if mo. = 1, total A1:B1 of mo. =2, A1:C1 if mo.=3 and
> so
> > on). Thank you.
>
>
>