=IF(TODAY()39264,0/0,SUM(A1:A15))

and

=IF(TODAY()39264,0/0,VLOOKUP(E33,C51:D55,2,FALSE))

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Kelly 1st" wrote:

Thank you!

Could you give me a little example as to how were to fit it in using the
already existing formulas below please?

1. =SUM(A1:A15)
2. =VLOOKUP(E33,C51:D55,2,FALSE)

Many Thanks

--
kelly m johnson
London


"Gary''s Student" wrote:

=IF(TODAY()39264,0/0,0)

will not work aftr the beginning of July
--
Gary''s Student
gsnu200712