Riki,On 2002-03-23 23:07, Riki wrote:
I have a list of rainfall data, ie
1.4
0.6
*0.2
How do I sum these three lines to get 2.2?
An * would normally only preceed the odd small number 0.8 and below.
Tks
Array-enter:
=SUM(IF(LEFT(A1:A3)="*",MID(A1:A3,2,LEN(A1:A3))+0,(A1:A3)+0))
where A1:A3 houses the values of interest.
To array-enter a formula, you need to hit control+shift+enter at the same time, not just enter.
Aladin
Like this thread? Share it with others