How do I set up a formula to count multiple items?

M

Mikaka

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
 
M

Mikaka

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
 
B

Biff

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
 
Top