In Final quality Score I need to return the Value where Yes is 0.5 and NO is 0 and I need total

Omii

KPH

Could you count the number of "YES"es and multiply by 0.5?

The COUNTIF function will count the number of cells that equal "YES", like this:

=COUNTIF([Confident Objection Handling]@row:[Follow Ups (Generating potential leads)]@row,"YES")

Then you can add *0.5 to the end

=COUNTIF([Confident Objection Handling]@row:[Follow Ups (Generating potential leads)]@row,"YES")*0.5

KPH

Could you count the number of "YES"es and multiply by 0.5?

The COUNTIF function will count the number of cells that equal "YES", like this:

=COUNTIF([Confident Objection Handling]@row:[Follow Ups (Generating potential leads)]@row,"YES")

Then you can add *0.5 to the end

=COUNTIF([Confident Objection Handling]@row:[Follow Ups (Generating potential leads)]@row,"YES")*0.5