|
|
Quote:
Originally Posted by CellShocked
On Mon, 25 Feb 2013 06:58:28 +0000, Mohamed72
wrote:
CellShocked;1609714 Wrote:
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.
Hi Cellshock,
I`m not following , would you kindely illustrate this in the attached
spreadsheet?
Best regards
+-------------------------------------------------------------------+
|Filename: sample.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=781|
+-------------------------------------------------------------------+
This probably isn't what you want either, but...
http://www.mediafire.com/view/?2bmnk07a19761wy
I did not perform any summing maybe after work today.
|
Deep Thanks Cellshock , the problem solved
|