I have a little problem that I'm struggling with on excel. I do have a number of macros (VB) enbedded which work fine but this one is a little beyond me.

Basically it is to add rainfall from 8 seperate cells (6***7):
=AddRainfall2(V965,AF965,AQ965,BI965,BR965,CD965,C P965,CY965)
The problem is any cell may contain 'TR', a number value (0.2 ~ 24 or anything etc) or may be blank, eg 8 cells may contain the following:
TR, TR, 0.2, ' ', ' ' , 0.1, ' ', 0.1 ~ the result of the 8 I would expect to see 0.4
or
TR, TR, ' ', ' ', ' ' , ' ', ' ', TR ~ the result of the 8 I would expect to see TR
or
2.0, 0.4, 3.0, 0.8, 0.3, 1.0, 0.2, 0.2 ~ the result of the 8 I would expect to see 7.9
As you can see there is 8x8 combinations = 64

If I didn't have 'TR' it would be quite simple to add up.

Any help from anyone that knows how to use excel would be nuch appreciated.

Many thanks

Keith (Southend)