Printable Version | Subscribe | Add to Favourites
New Topic New Poll New Reply
Author: Subject: Excel formula help
Mr Whippy

posted on 5/7/13 at 11:55 AM Reply With Quote
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]

View User's Profile E-Mail User Visit User's Homepage View All Posts By User U2U Member
luke

posted on 5/7/13 at 12:03 PM Reply With Quote
can you not use the =sum function? Just add up the cells?
View User's Profile View All Posts By User U2U Member
mark chandler

posted on 5/7/13 at 12:12 PM Reply With Quote
^^^

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 ?

View User's Profile View All Posts By User U2U Member
Mr Whippy

posted on 5/7/13 at 12:23 PM Reply With Quote
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

View User's Profile E-Mail User Visit User's Homepage View All Posts By User U2U Member
Agriv8

posted on 5/7/13 at 12:42 PM Reply With Quote
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 .............


View User's Profile View All Posts By User U2U Member
adampage

posted on 5/7/13 at 12:55 PM Reply With Quote
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

View User's Profile View All Posts By User U2U Member

New Topic New Poll New Reply


go to top






Website design and SEO by Studio Montage

All content © 2001-16 LocostBuilders. Reproduction prohibited
Opinions expressed in public posts are those of the author and do not necessarily represent
the views of other users or any member of the LocostBuilders team.
Running XMB 1.8 Partagium [© 2002 XMB Group] on Apache under CentOS Linux
Founded, built and operated by ChrisW.