Jul 01 2019 02:53 PM
Looking for help with Vlookup
Trying to use a formula and I think VLookup or Lookup is the solution.
Want to find the total revenue for the office ORD from the table below. Result should be ($1795 + $1295 + $1150 + 310) = $4550.
VLookup gives me just the first solution - $1795. So I think i'll need to add them up some way.
Jul 01 2019 03:07 PM
That could be like
=SUMIF($B:$B,"ORD",$F:$F)
or you may use ranges instead of entire columns