On Sunday, 18 June 2017 21:11:30 UTC+1, Norman Lynagh wrote:
Keith Harris wrote:

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)

Not sure how you have this set up but if you could force it to substitute 0.0
for TR then that would surely solve your problem. Perhaps it might be necessary
to use something like 0.001 rather than 0.0 so that you would have a total
above 0.0 if there were any traces.

--
Norman Lynagh
Tideswell, Derbyshire
303m a.s.l.
http://peakdistrictweather.org
Twitter: @TideswellWeathr

Thanks John, I just had a go with that function, but atm, no joy.
I was also thinking about changing the TR to 0.01 but that would have to be a change to the synop code eg: 69907 to ?

Keith (Southend)