Hi Greetings of the day to you.

any help
this work good,
=SUMPRODUCT(--(THREED(Sheet2:Sheet3!C6:C23)=C6),--THREED(Sheet2:Sheet3!D6:D23))

but unfortunately, the sheets have different ranges for summing.
like (sheet2!d3:d550)+(sheet3!d3:d750) instead of
--THREED(Sheet2:Sheet3!D6:D23)
and look range as THREED(Sheet2:Sheet3!C6:C750)=C6

Hi Eddy

I understand that Sumproduct need to have identical ranges and doesn't work
if the ranges are different.
Maybe, you can try the array formula ( confirm by ctl,shfit, enter) SUM(if....

let me know if you need further assistance, I'll try
HTH
--
If this posting was helpful, please click on the Yes button

Thank You

cheers,









"Eddy Stan" wrote:

Hi Greetings of the day to you.

any help
this work good,
=SUMPRODUCT(--(THREED(Sheet2:Sheet3!C6:C23)=C6),--THREED(Sheet2:Sheet3!D6:D23))

but unfortunately, the sheets have different ranges for summing.
like (sheet2!d3:d550)+(sheet3!d3:d750) instead of
--THREED(Sheet2:Sheet3!D6:D23)
and look range as THREED(Sheet2:Sheet3!C6:C750)=C6