Originally Posted by CellShocked

On Sun, 24 Feb 2013 11:14:59 +0000, Mohamed72
wrote:


Hi,
In the attached spreadsheet, i created a dropdownlist consisting of 3
associates` items (Nermine, Heba and Mohamed) and used the Vlookup
function to lookup for the data of each item. Now i`ve got two
problems:

1- How can i add and enter ( payed) column for each item ?

2- How can i calculate the sum of payed price for each associate ?
Regards


+-------------------------------------------------------------------+
|Filename: sample1.jpg |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=777|
|Filename: sample 2.jpg |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=778|
|Filename: sample 3.jpg |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=779|
+-------------------------------------------------------------------+


When you make the "table" which contains the items you wish to use in a
drop-down list, you should give the table a range name, then your list
criteria would simply refer to that range name as in:

=table_name_here

Then, any columns or rows you add to the worksheet will adjust the
location of that named range auto-magically. Of course your named range
replaces "table_name_here".

I keep my lookup list tables on separate worksheets.


For the tally results you should create and use a pivot table.