Focusing on this line alone:
.. formula on column d to show number "1" if column a to c not blank

Assuming data will be entered in cols A to C in row2 down
In D2: =IF(COUNTA(A2:C2)0,1,"")

Assuming cols A to C in row2 down
may contain formulas returned blanks: "", use this
In D1: =IF(SUMPRODUCT(--(A2:C2<"")),1,"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"vicki" wrote:
column a column b column c column
d
john 3, 12 2,3
peter
Mary 12, 24 26


please help with the forumula on column d to show number "1" if column a to
c not blank