Sum of a subset

[Gunder]

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!

 

[Mike H]

Hi,

Your not providing a lot to go on but maybe this. It will sum column E if
the date in column A is >= to today and if the conditions fof rcolumns B, C &
D are met

=SUMPRODUCT((A1:A13>=TODAY())*(B1:B13="a")*(C1:C13="b")*(D113="c")*(E1:E13))

Mike

 

[Gunder]

Thanks I think this will help me some of the way!

In addition: If there are dates in the follow up array that is <today()
there is not going to show any value, just a text like "Pipeline outdated".
In your example only the rows with a valid date will be summarized, but I
will not summarize at all if not all the rows of the sales person is updated.

Any suggestions on this?