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