I have 2 cells: A2,A4 which calculate the beginning and
the end of a (dynamic) range I use in the following
formula:

SUMPRODUCT((SummaryAll!$I$5:$I$202=$B8)*(SummaryAl l!
$J$5:$J$202=$C8)*(SummaryAll!$G$5:$G$202=$E$7)*(Su mmaryAll!
$L$5:$L$202))

5 being the beginning of the range calculated in A2
202 being the end of the range calculated in A4

Now, instead of manually replacing 5 and 202 by the new
values in A2 and A4. I would like my formula to update
itself with the help of INDIRECT.

If this works, I would like some help with the syntax, I
have tried almost everything but nothing works so far.
The formula itself is OK for it gives me accurate results
when I update it manually.

Or, if there is a "leaner" shorter formula that could work
I would gratefully appreciate any pointers.

Thanks in advance.