John wrote:
I am trying to get the syntax of a COUNTIF function correct and am having a
little problem. I am trying to COUNTIF a number of separate cells within the
formula as opposed to a range. For example

COUNTIF(A1,C1,E1"1") - this produces an error within the formula

Not sure if you can only do a continuous range i.e. COUNTIF(A1:E1,"1"), my
problem is I don't want to count B or D


Thanks



If the counting is restricted to just 3 cells...

=(A11)+(C11)+(E10)