Sumproduct

  • Thread starter Thread starter Steved
  • Start date Start date
S

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.
 
What ranges should be checked:

H4:H4 doesn't look right. H3:h26??
Same with I2:i2. I3:i26???
 
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
 
Post your current formula.

And check to see if any of the cells in those ranges contain errors themselves.
 
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.
 
Back
Top