I would like AI to to add 10 for every cell (B2:AH2) that has Y in it.
JE McGimpsey - 31 May 2008 06:15 GMT
One way:
=10*COUNTIF(B2:AH2,"Y")
> I would like AI to to add 10 for every cell (B2:AH2) that has Y in it.
Todd A - 31 May 2008 19:59 GMT
Hello Kevin,
Did the previous response help you?
> I would like AI to to add 10 for every cell (B2:AH2) that has Y in it.