Thread: COUNTIF?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Malcolm Austin Malcolm Austin is offline
external usenet poster
 
Posts: 15
Default COUNTIF?

I am attempting to count the number of "X" in non adjacent cells, but have
had no success so far.

I have recurring table for 12 people being surveyed, so that I am looking to
count how many
people have certain experience which the X signifies.

Using the insert formula I get this:

=COUNTIF(C12,I12,O12,U12,AM12,AS12,AY12,BE12,BK12, BQ12,"X")

The error is "too many functions"

Can anyone assist please, on modifying my formula (or identifying a
different formula?) to clear
the error?

Many thanks,
Malcolm