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

You can use SUMIF for that.

=SUMIF(SearchRange,SearchCriteria,SumRangeIfDiffer ent)

=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/sh...ad.php?t=45617

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:

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

Depending on your data table, there a few functions in Excel that you can
use.
I recommend that you post your example and the result that you want in order
that a solution be provided

--
HTH

Appreciate that you click the Yes button below if this posting is helpful

cheers, francis

"shah" wrote in message
...
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