nested color index within sumproduct

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

George P - 13 Jun 2007 19:46 GMT

i need to sum values of a specific fill color AND other criteria. i wrote:

=SUMPRODUCT(--(colorindex(BN3:BN530)=colorindex(C619)),--(B3:B530=B620),--(C3:C530=C620),(BL3:BL530))

but its returning #NAME?

i am replicating this formula from another sheet performing a similar task
but its not working here.

thanks for your help.
George

Reply to this Message

Toppers - 13 Jun 2007 20:23 GMT

What is colorindex? It is not a valid Excel function, hence the #NAME error.

Take a look here to see if this will help:

http://www.cpearson.com/excel/colors.htm

> i need to sum values of a specific fill color AND other criteria. i wrote:
>
[quoted text clipped - 7 lines]
> thanks for your help.
> George

Reply to this Message

Bob Phillips - 13 Jun 2007 20:34 GMT

The other sheet must have a ColorIndex UDF that you need to copy across, it
is not a built-in.

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>i need to sum values of a specific fill color AND other criteria. i wrote:
>
[quoted text clipped - 7 lines]
> thanks for your help.
> George

Reply to this Message