[Year 12 IPM] Re Excel problem

[Janette Bennie]

Hi Jock,

I added an extra column, column c.

I then used nested If statements to test, eg. Cell A2 then B2.

The formula in cell C2 would be:

=IF(A2="R",IF(B2="F",1,0),0)

I copied this formula for C2 - C7.

As a result, the cells in C would have the value 1 if A2 = R and B2 = F, 
otherwise it would contain 0.
I then used the SUM feature to add all the 1's up in column c to get the 
total.

I've attached the modified spreadsheet for you to see. Hope this helps

Cheers,
Janette Bennie (CRT).

>From: ga at willihigh.vic.edu.au (Jock Garnsworthy)
>Reply-To: "Year 12 Information Technology Processing and Management 
>Teachers'Mailing List" <ipm at edulists.com.au>
>To: ipm at edulists.com.au
>Subject: [Year 12 IPM] Re Excel problem
>Date: Wed, 29 Mar 2006 21:01:07 +1100
>
>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


><< countissue.xls >>

_________________________________________________________________
Shopping made easy @ tradingpost.com.au 
http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fwww%2Etradingpost%2Ecom%2Eau%2F%3Freferrer%3DnmsnHMetagv1&_t=753082530&_r=emailtagline&_m=EXT
-------------- next part --------------
A non-text attachment was scrubbed...
Name: countissue(1).xls
Type: application/octet-stream
Size: 33792 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20060330/d449646f/countissue1-0001.obj