[Year 12 IPM] Excel problem

[P. Barrera]

Hi Jock,

Try something like this: How many "r" in Barrera (type barrera in excel A2)
Type formula in B2           =SUM(LEN(A2))-SUM(LEN(SUBSTITUTE(A2, "r","")))
Answer = 3

Actually I just found same example and others,
http://www.emailoffice.com/excel/arrays-bobumlas.html

God luck,

Patricio Barrera

At 08:14 PM 29/03/2006, you 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