vlookup shah 12/31/2008 10:13:01 PM i'm doing a profit and loss account using figures from a transaction data sheet, the data have a lot of different figures of something i.e. sales. how do i get excel to lookup a category (sales) from a table of data then then adding all of the sale figures together to give the total sales. i've tried vlookup but it only gives one of the figures instead of all of them added together. i might be using the wrong function, if so can you tell me which one i should be using

Re: vlookup JBeaucaire <JBeaucaire.3lb0qb[ at ]thecodecage.com> 12/31/2008 10:26:34 PM You can use SUMIF for that. =SUMIF(SearchRange,SearchCriteria,SumRangeIfDifferent) =SUMIF(A1:A100,"Socks",B1:B100) -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=45617

RE: vlookup Shane Devenshire 12/31/2008 11:06:01 PM Hi, And if you have a lot of categories you want to do this for, then a pivot table is a nice solution. -- If this helps, please click the Yes button Cheers, Shane Devenshire "shah" wrote: [Quoted Text] > i'm doing a profit and loss account using figures from a transaction data > sheet, the data have a lot of different figures of something i.e. sales. how > do i get excel to lookup a category (sales) from a table of data then then > adding all of the sale figures together to give the total sales. i've tried > vlookup but it only gives one of the figures instead of all of them added > together. i might be using the wrong function, if so can you tell me which > one i should be using >