FIND function to exclude specific content?

[Viktor86HUN]

Hi

The whole code is looking up a whole sheet and summing it up for a pivot table. What i would like to achieve is to exclude the rows with specific TEXT in it.
I think it should be specified here. The word: EXCLUDED always can be found in column A

Please Login or Register  to view this content.

Can it be changed to exclude if text is EXCLUDED.
Or is there a way to seperate those cells with: what"*" or Lookin?


Here is the whole code maybe it's usefull:

Please Login or Register  to view this content.

[Viktor86HUN]

didn't know srry.
Fixed it already, hope i'll get an answer soon

[Viktor86HUN]

still trying, no result though, anyone could land me some help please?

[Viktor86HUN]

no luck yesterday looking for a solution today aswell