Thread: Sumif Rainfall
View Single Post
  #18   Report Post  
Kay
 
Posts: n/a
Default

Tks Arvi !

KC

On Mon, 29 Nov 2004 10:23:41 +0200, "Arvi Laanemets"
wrote:

Hi

Another one (an array function too)
=SUM(IF(ISNUMBER(SUBSTITUTE(D5:D35,"*","")*1),SUB STITUTE(D5:D35,"*","")*1,0)
)