Re: Few questions

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 15:52:25 +0200

Hi
see inline

[...]
 - "Work out the percentage of grade A*-C grades for that group" -
> each entry in column H has a grade ranging from A*, A, B,C,D,E,F
> etc.... I want to work out how many of the letters in column H are
> actually A*, A, B and C.

for counting
=SUM(COUNTIF(H1:H30,{"A~*","B","C"}))

for percentage:
=SUM(COUNTIF(H1:H30,{"A~*","B","C"}))/COUNTA(H1:H30)

> - "Work out the target percentage of A*-C grades" - I want to work
> out in a selected number of rows, for example rows 1:30, how many of
> the letters in column F are A*,A,B,C.

for counting
=SUM(COUNTIF(F1:F30,{"A~*","B","C"}))

for percentage:
=SUM(COUNTIF(F:F30,{"A~*","B","C"}))/COUNTA(F1:F30)

> - In column C, pupils all have different numbers ranging from 1-200.
> I want to look at each row and if the number in column C is above 95,
> They should have the letter A*, A, B or C in column H. I want to see
> how many do have this and how many don't.

for matching values:
=SUMPRODUCT((C1:C100>95)*(H1:H100={"A*","A","B","C"}))

for non matching values:
=SUMPRODUCT((C1:C100>95)*(H1:H100={"D","E","F"}))

Relevant Pages

  • Re: How to examine tokens?
    ... Okay, I was a little vague about the project, it's not just counting ... letters, it has to figure out how many letters are in each word, how ... compare this damn tokento a character. ...
    (alt.comp.lang.learn.c-cpp)
  • Re: generating unique letter combinations
    ... Instead of counting numbers, you count letters ... If your character set has all of the letters contiguous ... Thad's solution shows a mapping from a counter to a string produced from ...
    (comp.programming)
  • Re: Help on word counting
    ... For a Text field in a FileMaker database, then counting the words and ... letters is fairly easy. ... question marks, exclamation marks, etc. ... text into separate words and then count or summarise (using Summary ...
    (comp.databases.filemaker)
  • Re: generating unique letter combinations
    ... > example, abc = abc, ab, ac, bc, a, b, c for any length string. ... Instead of counting numbers, you count letters ... If your character set has all of the letters contiguous (like ...
    (comp.programming)
  • Re: Epistemology 201: The Science of Science
    ... > The first things kids see in the context of reading is books then ... > pages then paragraphs then perhaps sentences then words then letters. ... And matching isn't the same thing as mapping. ...
    (sci.cognitive)