Copper Contributor

I have a formula like this in a simple spreadsheet that adds a task mark and a test mark:


The difficulty is that in this range is a "a" for a learner that were absent for a test but the task was done.

How can I change this formula so that the "a" will be accommodated but not added or counted and just one of the marks will be added to the value?


1 Reply


My guess: