Hello JimR

Because you’ve given no explanation for the location and relationship
between columns I can only guess at what your data might look like.
However, this might help you out.

=SUM(INDIRECT("A5:"&LEFT(ADDRESS(1,DAY(TODAY()),4) ,IF(DAY(TODAY())<27,1,2))&65536))

Paste this formula anywhere above row 5, will sum columns per day for a
month.

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=519886