A 13 period exercise
 

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.

Hi SteveD,

What are you trying to do here? SUMPRODUCT doesn't seem appropriate for
comparing one cell to another, IF will do that fine.

The formula you show seems easier as

=IF(AND('From Charters'!$B$74=$B$5,'From Charters'!$F$17=$A$45),From
Charters'!$G$74,0)

--
HTH

Bob Phillips

"Steved" wrote in message
...
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.