Hello from Steved

In a sheet called summary I have the below formula.
'From Charters'!$B$74=$B$5 is period ie in this case period.4
'From Charters'!$F$17=$A$45 is Charter Kilometres (Other)
'From Charters'!$G$74:$G$74) this is okay if I stipulate G74

Ok my issue is $G$74:$G74 I want it to be $G$1:$G900

Why is because period 5 will be $G$93:$G93, I would like to automate this
process

=SUMPRODUCT(--('From Charters'!$B$74=$B$5)*--('From
Charters'!$F$17=$A$45)*'From Charters'!$G$74:$G$74)

Thankyou.