View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default How do I set up a formula to count multiple items?

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