Thread
:
Sumif Rainfall
View Single Post
#
18
Kay
Posts: n/a
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)
)
Reply With Quote