Sumproduct

[Steved]

Hello from Steved

=SUMPRODUCT(--('Paradox-Kilometres'!H4:H4=$A4),--('Paradox-
Kilometres'!I2:I2=$C3),'Paradox-Kilometres'!$I$3:$I$26)

I am working in worksheet called To Depots
In Paradox-Kilometres Worksheet the value in cell I3 is
what I need to go into worksheet called To Depots in cell
C4
I am getting #VALUE!

Yes it is all on the same Workbook, with two worksheets as
named.
Please is there another formula or what is not right with
the above.
Thankyou.

 

[Dave Peterson]

What ranges should be checked:

H4:H4 doesn't look right. H3:h26??
Same with I2:i2. I3:i26???

 

[Steved]

Hello Dave from Steved

Yes I have done what you asked me to do,
now I am getting #REF!

ps I have examples on my other worksheets that work but
this one has stumped

Thankyou for your reply

 

[Dave Peterson]

Post your current formula.

And check to see if any of the cells in those ranges contain errors themselves.

 

[Steved]

Thankyou Dave

I will take a look at this again maybe you are on to
something I may have missed

Thankyou ps If I still have problems I will do as you ask
and repost my Formula

Thankyou.