The formula is?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ziv" wrote in message
...
anyone knows why when i use the conditional sum wizard the array works but
if
i take the sum function out and leave it as an if function the array
dosent
work any more ?