Hi all,

I'm using this formula -

=IF(COUNTA(Markbook!E57:GB57),COUNTIF(Markbook!E57 :GB57,"ü")/COUNTA(Markbook!E57
:GB57)*100,"")

It is working out as a percentage how many times a symbol appears in
that range.

However, the symbols being counted are inserted into every other
column. In the columns in between, other data is being placed.

The formula is counting every cell in the range that contains data, but
what I want is for it to just count every other column that contains
symbols.

Is this possible?

Thanks,

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=506179