Thanks a lot to both of you.
Bit of a bummer really, as the cells I need to 'countif' are not needly and
evenly distributed.

Lets see if I can be creative with your solution though...

Thanks again!

Gr Frank

"Peo Sjoblom" wrote:

Not possible, you need to use either multiple countifs, or if your
cells always are a1, a3, a5 and so on (every other cell) you can use

=SUMPRODUCT(--(A1:A150=1);--(MOD(ROW(A1:A150);2)=1))

will count 1 in a1, a3, a5, a7 etc


--

Regards,

Peo Sjoblom


"FHE" wrote in message
...
I would like to use the CountIf statement but applied to a set of
separated
cells, rather then a range.

like countif((a1;a3;a5;a7);1).

However I get a 'value' error on this.

Anythoughts?