[Year 12 IPM] Re Excel problem

[Zach Alexakos]

Jock,
this will work.
=COUNTIF(A2:A7, "R")

Zach Alexakos





At 08:01 PM 29/03/2006, you wrote:
>Hi Peter,
>
>The attached file probaly explains better what I am after.
>
>Cheers
>
>Jock
>
>
>On 29/3/06 7:39 PM, "Peter Ruwoldt (wrk)" <pruwoldt at bigpond.net.au> wrote:
>
> > i do not think that there is a function that will count the number of
> > times a particular character appears in a cell which is what I
> > understand is the problem.  countif certainly will not do that.  You
> > would need to have a working area that broke the cell up into individual
> > characters using probably the  mid() function and then use countif to
> > tallly the number of times that a particular character appeared in that
> > area.
> > Peter
> >
>_______________________________________________
>http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
>IPM Mailing List kindly supported by
>http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and
>http://www.vitta.org.au  - VITTA Victorian Information Technology 
>Teachers Association Inc