I am doing a SUMPRODUCT calculation to put together a pipeline with many
different variables (among other sales person), this works ok. Now I want to
expand this so if there is a date in the array that is not today or in the
future the calculation shall show "Not updated".

How can I on the subset I have got (using SUMPRODUCT with several varables)
put in a check on the date of each row to be sure it is updated?

If not all rows for a salesperson is updated the calculation shall not show
the calculation result at all for that salesperson. In that way it is obvious
who of the sales persons that are updating their pipeline and who are not.

I have tried with several IF construction but I have not succeded, any
advice would be appriciated.

Thanks in advance!