Thread: If function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default If function
One way:

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

In article ,
Kevin wrote:

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