Thread: How to add (sum) a row cells with letter(s) aside or without numbe
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Héctor Miguel Héctor Miguel is offline
external usenet poster
  
Posts: 434
Default How to add (sum) a row cells with letter(s) aside or without n
hi, !

... the... formula, =countif(c3:n3,"le")*7.5+sumproduct(if(left(c3:n3, 2)="le",--substitute(lower(c3:n3),"le",0)))
with CSE smoothly doing its work...

glad to be in help, thanks for the feed-back

regards,
hector.

p.s. don't forget what you just learned in "Hints and Tips for New Posters" ;)


Reply With QuoteReply With Quote