A 13 period exercise

S

Steved

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.
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top