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