Hi Gijs,

Am Fri, 7 Jul 2017 05:01:35 +0100 schrieb GijsKijlstra:

INTRODUCTION: based criteria in columns A through H, matching column M,
numbers in column Q need to be multiplied with numbers in column i, and
the result added

=SUMPRODUCT(($A$3:$H$93=$M107)*(Q$3:Q$93)*($I$3:$I $93))

ISSUE: column Q contains besides numbers, also text. (without text in
column Q, the formula works like a charm. However with the text in
columns Q, it returns #VALUE)

try it with SUM. SUM ignores text and errors:
=SUM(IF($A$3:$H$93=$M$107;$Q$3:$Q$93*$I$3:$I$93))
and enter the formula with CTRL+Shift+Enter


Regards
Claus B.
--
Windows10
Office 2016