question though, why the division by two?

Countif counts each instance of the criteria. Since "e" has the value of 0.5
you can either divide the total count by 2 or multiply that total count by
0.5:

=COUNTIF(A1:J1,"x")+COUNTIF(A1:J1,"e")/2
=COUNTIF(A1:J1,"x")+COUNTIF(A1:J1,"e")*0.5

Dividing by 2 saves a couple of keystrokes!

Biff

"Mikaka" wrote in message
...
works great, thanks...

question though, why the division by two?