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

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

"George P" wrote:

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

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

--
HTH

Bob

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

"George P" wrote in message
...
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