In Excel, add 1 if not number, or else add the number -

in excel, how write formula following:

in cell range, if cell contains non-numeric entry, add one, or else add number cell contains.

for example

4
xyz
def
bc
2
0

=9

1
ab
cd
2
af

contents of data a1:a6

4
xyz
x
2
y
0

write following formula in cell b1

=sum(a1:a6)+(counta(a1:a6)-count(a1:a6))

Brande