Hi,

Does anyone know if SUMPRODUCT can be used as an array formula?
If this is the case, what is the syntax and can the syntax include conditions?

If it works, I would imagine that the syntax looks something like this:

{=SUMPRODUCT(IF(logical_tests,value_if_true,""),IF (logical_tests_value_if_true,""))}

However, if SUMPRODUCT doesn't work like an array formula, I don't want to
waste time trying to figure it out. Please let me know if you have any
experience with this.

Thanks,
Henrik