Does Excel support Alphanumberic formulas?
 

In my work, Patients earn "Points" for specific goals and I enter the total
in an excel spreadsheet, however, some days are "F"ree and some are "P"ass
days and only the letter is used. Is there a formula in excel I can use to
combine alpha and numberic data and still get sum, and avg results?

Does Excel support Alphanumberic formulas?
 

You can use the Countif() function.

For example:

=SUM(C1:C20,COUNTIF(C1:C20,"F"))

If you're going to combine the count (total) of "F" and "P", try this:

=SUM(C1:C20,COUNTIF(C1:C20,{"F","P"}))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"BryanP Man" <BryanP wrote in message
...
In my work, Patients earn "Points" for specific goals and I enter the
total
in an excel spreadsheet, however, some days are "F"ree and some are "P"ass
days and only the letter is used. Is there a formula in excel I can use
to
combine alpha and numberic data and still get sum, and avg results?