Formula issue

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

Steved

Hello from Steved

=SUMPRODUCT(--(ParadoxBusType!H3:H5=B35),ParadoxBusType!
I3:I5)

The above is functioning, but the below is not, what have
I done wrong please.

=IF(ParadoxBusType!H3:H5=B35,ParadoxBusType!I3:I5,"")

Thankyou.
 
Hi Steve

maybe try
=IF(ParadoxBusType!H3:H5=B35,SUM(ParadoxBusType!I3:I5),"")

entered as an array (ctrl & shift & enter)

Cheers
JulieD
 
Hello Julie

I entered your formula as an array but the cell has
no value.

Ok what I am trying to acheive, H3:H5 is for the range to
find B35 "M" in this case I3:I5 is the value range in
this case it will return 37. So by using your formula I
would like to have the cell blank if their is no value ie
37. If you can suggest a formula using the above criteria
I would be grateful. Or have I misred you formula.

Thankyou.
 
Hi Steved
what are you trying to do?. You can't check a range of
cells tin this way. what is your expected result?
Do you mean=IF(ISNA(VLOOKUP(B35,ParadoxBusType!
H3:I5,2,0)),"",VLOOKUP(B35,ParadoxBusType!H3:I5,2,0))
 
Hello Frank

I've had a hard day at work and have not thought it
through probably, your formula has done what I required.
and I Thankyou.

Cheers
 
Back
Top