Yippeee!! It's now working! Thank you so much. I'm not sure what was wrong
with it before as I had tried this previously. In the end I deleted all the
CF's and re-did them. That seemed to do the trick. :)

Would it be possible for me to now count and sum the cells containing red
text?

Thank you to you and Pete for your time and assistance. You've saved me a
lot of trial and error time!

"Dave" wrote:

Hi,
Not sure if you'll have any more success than you're having with Pete's
suggestions, but here goes:
Select all cells in the range U2:IU197. Make sure you start the selection in
cell U2. When all cells are selected, U2 should be the only one that looks
different.
With all that selected, open the CF window, select formula is, and enter:
=U$1=TODAY()-365
Select the CF's you want.
OK.

I've tested this here, so it should work...

Regards - Dave.