Please suggest a more compact format for this formula:
=SUMPRODUCT(
(INDIRECT("RawData!B"&$I$32&":B"&$J$32)=105)*
(INDIRECT("RawData!AA"&$I$32&":AA"&$J$32)="M6")*
(INDIRECT("RawData!AG"&$I$32&":AG"&$J$32)="CLOSED" )*
(INDIRECT("RawData!P"&$I$32&":P"&$J$32)="CLOSED")*
(INDIRECT("RawData!AD"&$I$32&":AD"&$J$32)=Calcula tedData!H2)*
(INDIRECT("RawData!AD"&$I$32&":AD"&$J$32)<=Calcula tedData!H3)*
(INDIRECT("RawData!AF"&$I$32&":AF"&$J$32)INDIRECT ("RawData!AD"&$I$32&":AD"&$J$32))*
((ISNUMBER(MATCH(INDIRECT("RawData!E"&$I$32&":E"&$ J$32),Definitions!$B$3:$B$6,0)))))
)

Also, is there a way to alias frequent constructs, like
("RawData!B"&$I$32&":B"&$J$32) and replace with a parametrized syntax, like
€œdata(B)€�, still using a worksheet formula.

Thank you.