Thread: Sumif Rainfall
View Single Post
  #15   Report Post  
Old November 29th 04, 11:05 PM
Max
 
Posts: n/a
Default

Stumbled across Aladin's 2 replies in Excelforum
(think his replies there somehow didn't propagate over ..)

Interesting deliberation. I presume you didn't see:
http://www.excelforum.com/printthread.php?t=320974


An his earlier post ..
If not inconvenient, go with R.VENKATARAMAN's suggestion.
Otherwise:

=SUM(IF(ISNUMBER(SUBSTITUTE(D535,"*","")+0),SUBS TITUTE(D535,"*","")+0,0)
)

which must be confirmed with control+shift+enter
instead of just with enter


--
Rgds
Max
xl 97
---
GMT+8, 1 22' N 103 45' E
xdemechanik <atyahoo<dotcom
----