Ken,

I'm assuming you have dates in A1 - A32 so tru this

=SUM(IF(DAY(A2:A32)=DAY(TODAY()),B2:B32,0))
It's an array so commit with Ctrl+Shift+Enter.

Mike

"Ken" wrote:

Excel2003 ...

Range A2:A32 contains Days of Month (1-31)
Range B2:B32 contains Values

Cell B33 ... I wish to SUM Col B Values from TODAY thru End of Month.

ie: If TODAY is 04/18 ... Sum B Values 04/18 thru EOM
ie: If TODAY is 04/19 ... Sum B Values 04/19 thru EOM

Thanks ... Kha