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

--
Biff
Microsoft Excel MVP


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