Thread: no blanks
View Single Post
  #3   Report Post  
Héctor Miguel
 
Posts: n/a
Default no blanks

skip blanks...
op3: =sumaproducto((s!d4:d1000)*(s!d4:d100=s!g4:g100))

regards,
hector.