If function

[Kevin]

I would like AI to to add 10 for every cell (B2:AH2) that has Y in it.

 

[JE McGimpsey]

One way:

=10*COUNTIF(B2:AH2,"Y")

 

[Todd A]

Hello Kevin,

Did the previous response help you?