Yes.

There nice thing about this approach is that you can extend it to cover a
lot more codes.
--
Gary''s Student - gsnu200821


"JDSkiing" wrote:

Thank you for the response, am I also able to use more than one letter for
example would =COUNTIF(B1:Z1,"F")+COUNTIF(B1:Z1,"FF")*1.5, also work if FF is
equal to 1.5, and can I copy this formula down among multiple rows

"Gary''s Student" wrote:

Say the data is in A1 thru Z1, In A1 enter:

=COUNTIF(B1:Z1,"F")+COUNTIF(B1:Z1,"G")*1.5

--
Gary''s Student - gsnu200821


"JDSkiing" wrote:

For example, If I wanted every time the letter F was input as data that,
within the fields marked that F would equal the number one, then for example
G would equal 1.5, so that if a row had three F's and 2 G's it would equal 6
if I totalled the row across. This is a simple xample of what I am trying to
accomplish, but if someone can show me this I can figure out the rest.
Thank you
James Deutschkron