poolshark,
in VBA,
evaluate("=SUM(OFFSET(A1,2,2+MONTH(TODAY())*4,1,4) )")
in worksheet
=SUM(OFFSET(A1,2,2+MONTH(TODAY())*4,1,4))
HTH
Cecil

"poolshark " wrote in message
...
Thank you in advance for any responses.

I am trying to make a cell sum a range of cells based on what month it
is according to the system clock. If the clock shows January then SUM
g3:j3, if the clock shows February then SUM k3:n3 and so on...
Thank you again.


---
Message posted from http://www.ExcelForum.com/