If this range holds any text values it will return a value error,
'Density Chart'!D3:D9427
text values can be blanks from formulas like "" or plain text
you can rewrite it as
=SUMPRODUCT(--('Density Chart'!A3:A9427=B3),--('Density
Chart'!B3:B9427=B4),'Density Chart'!D3:D9427)
that will ignore text or fix the txt values in that range
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
"Correna" wrote in message
...
Received help with this one before (see Excel Formula - 5/3/2006) and now
the
formula works great for the worksheet labelled "Correction Values". But
now,
almost the exactly same scenerio with a worksheet labelled "Density Chart"
but I am getting a #VALUE! error.
Are my eyes just tired and I'm missing something?
=SUMPRODUCT(('Density Chart'!A3:A9427=B3)*('Density
Chart'!B3:B9427=B4)*('Density Chart'!D3:D9427))