Thread: Sumif Rainfall
View Single Post
  #11   Report Post  
Old November 29th 04, 07:23 PM
Biff
 
Posts: n/a
Default

Hi!

=3DSUMPRODUCT(--(SUBSTITUTE(SUBSTITUTE
("0"&A1:A10,"Trace",""),"*","")))

Still shorter and still not an array with less function=20
calls! <g

Biff

-----Original Message-----
....and doesn't seem to tolerate empty cells.

KL

"Max" wrote in message=20
...
"Biff" wrote:
...
Here's something a little shorter
and it's not an array:
=3DSUMPRODUCT(--(SUBSTITUTE(SUBSTITUTE
(D535,"trace","0"),"*","")))


Think it's case sensitive, Biff
(unlike the longer, array formula <g)

Had to change "trace" to "Trace"
before it worked ..

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


.