View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bondi
 
Posts: n/a
Default sumif function when left 4 texts are matching

Hi,

Maybe you can use the wildcard *

=SUMIF(C88:C97,"FR LH*",D88:D97)

Regards,
Bondi