Hi,

Am Tue, 18 Nov 2014 05:36:14 -0800 (PST) schrieb
:

Jul-13 Aug-13 Sep-13 Oct-13............Total
Value1 Value2 Value3 Value4........ Sum(n0:n+k)

A1: Input Date

try:
=SUM(OFFSET($Q$4,,,,MATCH(A1,Q3:AZ3,0)))
or
=SUM(INDIRECT("Q4:"&ADDRESS(4,MATCH(A1,A3:AZ3,0))) )


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional