Forum Discussion
dleesBLX
Jul 01, 2019Copper Contributor
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...
SergeiBaklan
Jul 01, 2019Diamond Contributor
That could be like
=SUMIF($B:$B,"ORD",$F:$F)
or you may use ranges instead of entire columns