Does Excel support Alphanumberic formulas?

B

BryanP Man

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?
 
R

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