I want to set up a formula to count certain items in a row based on what the
content is.

So, if the cell contains an "x" count it as 1, if it contains an "e" count
it is 0.5, and then add up the values.

I hope that's clear enough

Hi!

Try this:

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

Biff

"Mikaka" wrote in message
...
I want to set up a formula to count certain items in a row based on what
the
content is.

So, if the cell contains an "x" count it as 1, if it contains an "e" count
it is 0.5, and then add up the values.

I hope that's clear enough

works great, thanks...

question though, why the division by two?

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?

wait, i think i understand why; you're dividing the second strand of values
that are counting the e's by two, thus giving me the 0.5