Hi Beaker,

As the turnover is an amount I suppose you could use SUMPRODUCT(). You'll find an example of this function on my site. Otherwise, if you don't succeed using SUMPRODUCT() you can try the MLOOKUP() user defined function that's also to be found on my site.

Erik