Pl go back and mark the earlier 2 responses by pressing their YES buttons.
Thanks.

As for your further query, use the SUMPRODUCT expression which was given
earlier instead of COUNTA
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"vicki" wrote:
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?