[Year 12 IPM] Excel problem

[Laurie Savage]

Not elegant but

1. from Excel help:
=IF(ISNUMBER(FIND("v",A2)),"OK", "Not OK") Checks to see if A2 contains "v"

2. use nested if statements in a third column to return 1

3. Sum the third column!

Laurie

Peter Ruwoldt (wrk) 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
> 
> 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
>>
>>   
> 

-- 
Laurie Savage
=============================================
Student Assessment, Reporting and Tracking
Pascoe Vale Girls College, 03 9306 2544
Lake Ave, Pascoe Vale, Victoria, 3044
=============================================