Forum Discussion
Sum of Vlookup results
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.
1 Reply
That could be like
=SUMIF($B:$B,"ORD",$F:$F)
or you may use ranges instead of entire columns
