Dear Max,

thanks thank.

may i ask for help for 1 more question:
(column a *b) (counta column
c, if not blank, "1")
1 column a column b column c column d
2 3 4 12 1
3
1

for the COUNTA formula, as it also count those cell which contain formula,
since column c has formula, so on row cell D3, the column d will also show 1,
but instead of show 1, can it be a blank cell?

thanks thanks again
--
vicki


"Max" wrote:

what is the meaning of the "--" on the formula of
=IF(SUMPRODUCT(--(A2:C2<"")),1,"")

It basically coerces TRUEs to 1s, FALSEs to zeros
The TRUEs/FALSEs are evaluated by this part: A2:C2<""

Hence: --(A2:C2<"")
will then result in a numeric array of zeros/1s
instead of TRUEs/FALSEs for sumproduct to evaluate

Pl mark ALL responses which help by pressing the YES buttons (like the one
below)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---