If that is how your data will always be laid out then try:

=SUM(INDEX(B2:B32,DAY(TODAY())):B32)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Ken" wrote in message
...
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