Does anyone have any suggestions on what wrong it is on using the indirect
function?

=SUM(--(TRANSPOSE(B$595:B$664)+A$2:A$90=H2)), which work fine,

I would like to change B$595:B$664 into a variable using indirect function,
=SUM(--(TRANSPOSE(INDIRECT("B$595:B$"&594+B$594))+A$2:A$9 0=H2))

but it returns #VALUE, does anyone have any suggestions what wrong this
statement is on using indirect function?
Thanks in advance for any suggestions
Eric

Note: This is an array formula that has to be confirmed with
CTRL+SHIFT+ENTER rather than just ENTER