SumProduct or Countif

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have 2 columns.
In column A the contents are X, Y or Z only.
In column B a range of rounded values from +3.00 to -3.00.
I want to display the %age of X for each value in column B (and then filter
and graph the results from Column C).

ie
A B C
.... ...... .......
X 1.20
Y 1.20
X 1.20
Z 1.20
X 1.20 60%
X 1.30

I can't figure the syntax (or maybe I should modify a SubTotal ??)
Any Help gratefully received.


.

Relevant Pages

  • Graphing
    ... I have a graph that is sorted by dates, ranging from 1998-2005. ... modify the graph before, ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Help - need to change an attribute value
    ... All I need to change is the syntax - we have it set at "Case Sensitive ... ' Retrieve attribute value. ... strDepartment = LCase ... To modify users in many OU/Containers throughout, ...
    (microsoft.public.windows.server.active_directory)
  • Re: Help - need to change an attribute value
    ... All I need to change is the syntax - we have it set at "Case Sensitive ... ' Retrieve attribute value. ... strDepartment = LCase ... To modify users in many OU/Containers throughout, ...
    (microsoft.public.windows.server.active_directory)
  • Re: best method to perform operations on word lists
    ... current purpose it'll do the trick but any suggestion for optimization ... my $prev = 'nonesuch584685542256RANOM58544'; ... This didn't modify the list. ... hence my thoughts about language files. ...
    (comp.lang.perl.misc)
  • Re: Order of evaluation and better declaration of functions
    ... Why burden documentation when code can communicate the same? ... modify .cpp, modify the incode documentation, modify design ... Please suggest alternative syntax. ...
    (comp.lang.cpp)