Does Excel support Alphanumberic formulas?

[Guest]

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?

 

[Ragdyer]

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"}))