Sum by Color Array Formula

[Co-op Bank]

Hello,

I've used www.cpearson.com excellent guidance on summing up the value of
cells by colour.

Is it possible to do an array formula version, for example summing the sales
of purple rows in a certain date range and by a specific sales person?

If anyone out there could help it would be much appreciated!

Thanks
Brian
Manchester

 

[Tom Ogilvy]

use sumproduct and adapt your function to return an array result.