summing results of multiple vloopups

  • Thread starter Thread starter dawnecia
  • Start date Start date
D

dawnecia

Can anyone help with the following vloopup formula?

=IF(ISNA(VLOOKUP($A4,RANGEA,3,FALSE)),0,VLOOKUP($A4,RANGEA,3,FALSE))+IF(ISNA(VLOOKUP($A4,RANGEB,3,FALSE)),0,VLOOKUP($A4,RANGEB,3,FALSE))+IF(ISNA(VLOOKUP($A4,RANGEC,3,FALSE)),0,VLOOKUP($A4,RANGEC,3,FALSE))

If there is a value in all three ranges it returns the currect amount.

Here are the problems:
- If RANGEA is missing a value it does not add RANGEB and RANGEC.
- It RANGEA and RANGEC are missing values it adds RANGEB to a value from
the cell above.

Any suggestions?

Thanks
 
Nothing wrong with the formula although it might be possible to use SUMIF
instead and save some complexity since you don't have dodge any N/A errors.

Anyway, formula works fine for me regardless if it find anything in the
different tables so maybe you have some "bad" data that isn't what it looks
like it is.

--


Regards,


Peo Sjoblom
 
Back
Top