Count formula issue
- From: mevetts <mevetts.22esoa_1138559701.5586@xxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 29 Jan 2006 12:33:52 -0600
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?action=getinfo&userid=29130
View this thread: http://www.excelforum.com/showthread.php?threadid=506179
.
- Follow-Ups:
- Re: Count formula issue
- From: Biff
- Re: Count formula issue
- From: Bob Phillips
- Re: Count formula issue
- Prev by Date: Re: Auto Worksheet
- Next by Date: Re: Problems copying a formula between worksheets
- Previous by thread: Re: How can I add up lookups? Finding days in a week of a month
- Next by thread: Re: Count formula issue
- Index(es):
Relevant Pages
|
