vlookup

[shah]

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

 

[JBeaucaire]

You can use SUMIF for that.

=SUMIF(SearchRange,SearchCriteria,SumRangeIfDifferent)

=SUMIF(A1:A100,"Socks",B1:B100)

 

[Shane Devenshire]

Hi,

And if you have a lot of categories you want to do this for, then a pivot
table is a nice solution.

 

[xlm]

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