# Sum of Vlookup results

Highlighted
Occasional Visitor

# 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
Highlighted

# Re: Sum of Vlookup results

That could be like

`=SUMIF(\$B:\$B,"ORD",\$F:\$F)`

or you may use ranges instead of entire columns