Skip to content

Instantly share code, notes, and snippets.

@Jason1976

Jason1976/excel-sumproduct01.vb

Last active January 22, 2018 05:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Jason1976/cd8d39933f5d64b82a39972f4c27215f to your computer and use it in GitHub Desktop.
Save Jason1976/cd8d39933f5d64b82a39972f4c27215f to your computer and use it in GitHub Desktop.
Download ZIP
EXCEL – 如何利用 SUMPRODUCT 一次搜尋多個關鍵字
Raw
excel-sumproduct01.vb
=SUMPRODUCT(--ISNUMBER(SEARCH($D$2:$D$5,A2)))>0
Raw
excel-sumproduct02.vb
=IF(SUMPRODUCT(--ISNUMBER(SEARCH($D$2:$D$5,A2))),"Yes","No")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment