vlookup and sum

  1. T

    Pls help Need to sum some "characters"

    Sorry, may be it's written somewhere but I didn't find... :( I need to sum some letter but on each letter corresponds number. I can make it with vloookup, but there will be many vlookups, can you help me to make it better... this sample table: <tbody> d d n n h p p d 8...
  2. M

    vlookup to sum different columns....BUT....

    HELLO EXCEL fans & pro's i have a have a matrix in a separate sheet a9:bb70 [where columns c9:bb9 are the 52 weeks of the year] each row [9 to 70] represents totals [hours] of a particular project in any of the 52 weeks i have another sheet where a user can select a period of time [start...
  3. M

    SUMIF & VLOOKUP Function

    Dear helpers, I am having difficulty creating a formula that I believe requires both a SUMIF and VLOOKUP function. I have been looking through other forums and Excel online help for a solution however haven't found one. My table looks like this: <colgroup><col style="width: 85pt...
  4. D

    Sum of Values Accross Multiple Columns in Multiple Worksheets Using VLOOKUP

    Hello, I am looking for the proper syntax to generate a sum of the bottom-most cell in each column across multiple worksheets. My current formula looks like this: =VLOOKUP(9.99999999999999E+307,'Z:\Warehouse\Inventory 2013\Spray Pens\[Spray Pens.xls]Anti-Static'!D$1:D$300,1) but the above...
  5. J

    Theatre Booking System query. vlookup?

    Hi, I am hoping I could get some assistance with an issue I am having on Excel! Let me start by saying I have searched other topics within the forum and can't seem to find the code which suits what I need...so here goes I have been trying to use a vlookup and a sum formula to find a show name...
  6. A

    Creating a VLookUp Function in VBA

    Hi all, First time poster here, so please let me know If I'm leaving anything out. Im trying to write a code in vba in Excel 2010 that would incorporate the vlookup function in excel. My Data Looks like this: <TABLE style="WIDTH: 384pt; BORDER-COLLAPSE: collapse" border=0...
  7. J

    VLOOKUP - Returning a sum of values from multiple sheets in workbook

    Hi there...:rolleyes: I'm trying to figure out how to return multiple values, added together, from a vlookup formula. Here is the scenario... Sheet 1 - called "Master Client Spend" <TABLE style="WIDTH: 256pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0...
  8. L

    VLook up & Sum

    When you do a v look up, how can you sum if you have more than one row with the same name. For instance: Column A Column B ExampleA $200 ExampleB $300 ExampleA $100 So if i do a =VLookUp(ExampleA,spreadsheet,A:B,2,0) =200 How can I do to get 300 which is the total of ExampleA...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top