lookup and sum

I've successfully used the below formula several places in my spreadsheet. However, when I point it to a cell range that has formulas in it, it only works for the value in cell G5. In the first row, the below formula points to cells w/calculations and only returns the last number in the row if...

Below is a smaller mock of the data I receive. The values are separated by a semicolon and hashtag. I've found numerous formulas that will return a sum of the values in the Requests column, however, none of them seem to work if the value is not the first value in the string. Mock of actual...

I'm pretty much self-taught on Excel, and I'm really having trouble with this... I have two worksheets in my spreadsheet, the first is Labour Tracking, the second Data. My Data worksheet has a list of seven employees in Column A and their corresponding wage in Column B. The number of...

Hi everyone, I really need some help as my brain has popped! I have a spreadsheet with three tabs. One is a dashboard to bring together values from the other two. The purpose is to calculate the quantity of items per county so I can determine volumes needed for storage. The sheets are...

My workbook is broken into 3 separate sheets, #1 I am entering in a daily amount of different bundles and or products which each have their own cell. This string of data is essentially copied to sheet #2 and deleted from sheet #1 as sheet #1 's only responsibility is the daily input. Sheet 2...

My first post. I have two tabs, Assets and Fuel. On the Asset tab I want to total the miles for my three vehicles, Jeep 1, Jeep 2 and Car 1. There are multiple columns on both tabs in addition to the ones I listed; I included only the bare necessities in this example. I have tried vlookup...

I have a yearly Summary tab (see below) which tracks the amount of chains sold per week. Column A is week beginning and Column B is "Chains", I have several more items but just need to concentrate on one as I will be able to work out the rest once given the first formula Week Beginning Chains...

<tbody> A B C 1 Savage 12/04/15 29,699.59 2 Huntington 12/09/15 27,725.74 3 Prestige 12/23/15 12,869.39 4 Concord 01/27/16 22,807.85 5 Kelly 02/01/16 4,833.24 6 Burlington 02/04/16 5,695.15 7 8 12/01/15 70,294.72 9 01/01/16 22,807.85 10 02/01/16 10,528.39 </tbody>...

Hi Guys Thanks for all the help - But now I sit with my most DIFFICULT problem yet and I don't even know where to start: I have 2 workbooks (Active Projects, VMC Display) WB - Active Projects <tbody> Date Project Number Audit JTO PTO 15/01/16 P-6200123 1 15/01/16 P-6200555...

I am looking for a way to populate a summary table. I export multiple sources of data, which all have the same information but arranged in a different way. The constant would be the date that I keep on the far left. So what I am looking for is a way to use the date then look up the column...

Hi All, I have a multi-sheet excel 2013. I want to use a lookup function that finds all the same types and sums the values. I tried Vlookup, but not all the categories have every type every month and I'd like it to stay static from month to month. I also tried Index, but it wasn't returning...

I am having trouble trying to workout how to do the below. <tbody> W/E 12/04/2014 19/04/2014 26/04/2014 03/05/2014 10/05/2014 17/05/2014 24/05/2014 Rev. 200 200 200 200 200 200 200 Cost. 100 100 100 100 100 100 100 </tbody> I would like to combine a LOOKUP and SUM to say the following...