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