How do I give a Text entry a value in the cell next to it?

[KathyDent1976]

Okay.. It's been a while since I've had my Excel courses. Here's th
scenario...

I have a worksheet that is tracking 'points' for a real estate sale
contest. Certain transactions performed with a property are 'worth
more points than others. Here's an example of what the columns loo
like:
------------ --------- -------------- ----------- --------------
-------------------- --------------
Address |-Sale-- |-Points: 1--|--Listing--|-Points: 2--|-In Hous
Sale--|--Points:3--
----------- -------- -------------- ----------- --------------
-------------------- --------------
123 A St.| Joe S. |------1------ |-Jane S.--|------2------|---Jil
S.------------|-----3-------
------------ -------- -------------- ----------- --------------
-------------------- --------------
456 B St.|---------|--------------| Sally T. |------2 ------|--Dav
R.---------|-----3--------
------------- --------- --------------- ------------ --------------
--------------------- --------------
My question is: How do I formulate the 'Points' cells to automaticall
populate with the correct number (1, 2, 3 points) just by typing tex
(the salesperson's name) into the column beside it? ALSO, how do
calculate all the points each salesperson has earned on anothe
worksheet if their name appears in different columns and row
throughout the worksheet (without doing =SUM ([and CTRL+clicking al
the different cells]) )??

Please Help!
-KL

 

[Biff]

Hi!

What criteria do you use to determine the points awarded?

Maybe something like this:

=IF(A1=criteria_1,1,IF(A1=criteria_2,2,IF
(A1=criteria_3,3,"")))

It would be helpful if you would post a better
representation of your actual data. All those dashes are
hard to decipher and are not aligned (at least in CDO).

Use cell references and specific column references.

Biff