Sum by Color Array Formula
 

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

Sum by Color Array Formula
 

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

--
Regards,
Tom Ogilvy


"Co-op Bank" wrote:

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