On Sunday, 18 June 2017 21:36:28 UTC+1, JohnD wrote:
Well, have a look at:

https://exceljet.net/formula/sum-if-...e-not-equal-to

Maybe my previous example should have been: SUMIF(range, "TR") - I think
this approach should work but, as ever, the syntax needs to be exactly
right.

Excellent and very helpful forum, really quick replies, yes, there are a couple of ways of doing it. John, you were very close to the easiest solution which is:

=IF(SUM(V965,AF965,AQ965,BI965,BR965,CD965,CP965,C Y965)0,SUM(V965,AF965,AQ965,BI965,BR965,CD965,CP9 65,CY965),"TR")

Happy days.

Many thanks once again for all your replies

Keith (Southend)