On 18/06/2017 20:25, 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)

My Excel skills wouldn't be up to this, but if you go to
http://windowssecrets.com/forums/ and register they have an Excel forum
(http://windowssecrets.com/forums/for...5-Spreadsheets)
which I'm sure will give you an answer. I am registered there and have
received help to my questions and have been able to help others on occasion.