[Year 12 IPM] Excel problem

Peter Ruwoldt (wrk) pruwoldt at bigpond.net.au
Wed Mar 29 19:39:00 EST 2006


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

Jock Garnsworthy wrote:
> Hi all, 
>
> I wish to count the number of entries that meet two conditions.
> Eg: Count how many times "R" appears in column A in the same row  as "F" appears in column B.
>
> I have tried to use the logical function "and" in conjunction with "countif" but can't seem to make it work.
>
> Anyone have a solution?
>
> ---
> Cheers
>
> Jock
> __________________________
>
> Jock Garnsworthy
>
> Williamstown High School (Pasco Campus)
> _______________________________________________
> 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
>
>   

-- 
If computers get too powerful, we can organize them into a committee -- that will do them in.

Peter Ruwoldt
ICT Coordinator
Grant High School
Hosking Avenue
MOUNT GAMBIER  SA  5290

P. 08 87263107 (Do not leave voice mail)
F. 08 87250173

ruwoldtp at granths.sa.edu.au
http://waraku.blogspot.com/




More information about the ipm mailing list