Mr Whippy
|
| posted on 5/7/13 at 11:55 AM |
|
|
Excel formula help
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]
|
|
|
|
|
luke
|
| posted on 5/7/13 at 12:03 PM |
|
|
can you not use the =sum function? Just add up the cells?
|
|
|
mark chandler
|
| posted on 5/7/13 at 12:12 PM |
|
|
^^^
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 ?
|
|
|
Mr Whippy
|
| posted on 5/7/13 at 12:23 PM |
|
|
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
|
|
|
Agriv8
|
| posted on 5/7/13 at 12:42 PM |
|
|
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 !!!
Taller than your average Guy !
Management is like a tree of monkeys. - Those at the top look down and see a tree full of smiling faces. BUT Those at the bottom look up and see a
tree full of a*seholes .............
|
|
|
adampage
|
| posted on 5/7/13 at 12:55 PM |
|
|
Keep it simple stupid....
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
|
|
|
