Hi,

Am Tue, 16 Dec 2014 18:15:31 +0000 schrieb Quilp:

I have had another thought Claus. The values I wish to ignore are
ignored because they are not valid until a certain date is reached after
which they can be included in the summation. Is there an alternative
solution to my problem bearing this in mind?

if you have a date in every row you could use SUMIF.
If the date in column A is greater or equal 01.01.2015 then the values
in B will be added:
=SUMIF(A1:A200,"="&DATE(2015,1,1),B1:B200)


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