You are a star as always.

That work perfectly. I think because I've adapted my spreadsheet  to work in
another way I didn't consider changing the way it counted the cells.

And by losing the references  i meant that the countif's would lose the reference
to which cell they were looking at and i an only presume it was my rubbish
statement that was doing it.

Once again thank you for your time.