Hi PoolShark!

One way. Try:

=SUM(INDIRECT("R3C"&3+(MONTH(TODAY())*4)&":R3C"&6+ (MONTH(TODAY())*4),0
))

I use INDIRECT with the False second argument to construct a
calculated R1C1 reference.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.