Sum up values from a list to a second location.

J

James

hi.. this is a little complicated but i believe that someone out there might
know it.

i have created a drop down list to assign a type of value , which is related
to an adjacent box. For example, the list can be buy, sell, trade, etc. after
i select a value for that box, i have to put the value in the adjacent box.
For example, if i select "buy" in A1, i put a manual value in A2 such as
$2.00.

On a different part of the work sheet, i need to sum up all of that type in
a box. For example if i have 5 "buy" boxes, i need them summed up in the
"total buy" value box, and so on.

is there a way to sum up all types of manual values based on what i
initially value the first box, such as buy sell etc?

thank you

james
 
T

T. Valko

Need a better explanation of you layout.

Where (exactly!) are the drop down cells and where (exactly!) are the cells
that need summed?

It sounds like you might have something like this:

A1 = buy
A2 = 10
A3 = buy
A4 = 15
A5 = sell
A6 = 3
 
K

Kevin B

You can use a SUMIF to calculate the values based upon categories.

In the following examples, the range containing the categories
(Buy/Sell/Steal/Whatever) is in Column A rows 1 through 9 and the values to
sum are in column B, rows 1 through 8:

=SUMIF(A1:A8,"=Buy",B1:B8)

The syntax of the formula is =SUMIF(CriteriaRange, Criteria, SumRange)

Change the ranges and categories as needed.

Hope this helps...
 
Top