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