Solved it using AGGREGATE(9,6,A1,C1,F1.G1).

9 = SUM and 6 = Ignore error values.

I knew there must be a simpler way than us loadsa 'IF' statements.

Seems to be a very useful function - haven't used it before.

Regards to all who have thought about this.

Alan