Hi

Normally I’m fine with formulas but this one has me stumped

I’m trying to get the total hours from two tables combined into one at the bottom where the resource and week match. I thought I’d use a vlookup function but that doesn’t seem to work.

Would anyone be able to help?

Thanks, Scott



[Edited on 5/7/13 by Mr Whippy]

can you not use the =sum function? Just add up the cells?

^^^

As above, why are you trying to make this hard or will table rows not always match making you look for the name then cross reference ?

Damn…cos it Friday 30 degs in here and I'm not thinking clearly....as usual thinking of the most difficult way to do a simple task

yes your right a sum function is the very obvious solution

Thanks, sorry brain fade moment there, I need a very cold beer

Mr Whippy Tou have a better excuse than Brain fade !!!

http://www.locostbuilders.co.uk/viewthread.php?tid=179759

there is a theory that babies kill brain cells !!!

I nearly posted a more complicated answer to this one, but as spotted, as long as the formats of the tables you're summing are the same, you can just sum them.....

If they weren't (i.e. rows in different orders, or something like that) then either a 2 level index/match, or a set of sumifs would've worked.

But let's not even go there!

Happy friday everyone...
Ad