Yes, DPRODUCT can be used with non-adjacent cells by using array formulas. This involves enclosing the database and criteria ranges in curly brackets and pressing Ctrl+Shift+Enter instead of just Enter to confirm the formula.