It is unclear what you are trying to achieve
Try explaining another way.
What do you mean by "title"? Are you thinking of what Excel calls a NAME -
look in Help
If Mike's title is 'a' what does 'a3' mean?
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Mike" wrote in message
...
Hi !
Please help me
Spreadsheet set out as follows

A B C
1 Total 0
2
3 New 0
4
5 Mark 0
6 Sally 0
7 James 0

Where I would like Mark to have a "title" value of say "a" no
quotes
Sally to have a "title" value of say "b"
James to have a "title" value of say "c"
Where if I enter the value "a3" (Mark's title) into cell B3 (new) it would
enter 3 into B3 and B1 as well as in Mark's cell B5
When enter is pressed B3 would return to zero
B1 would reflect 3 (new)
B5 would reflect 3 (mark)
B6 would reflect 0 (sally)
B7 would reflect 0 (james)

If adding the value b6 into cell B3 (new)
Would add 6 to sally's mark
As well as adding it to B1 giving a total of 9
And resetting B3 (new) to zero
The same would happen if b9 was added into cell B3
That number would be added to James and onto whatever total was in B1
Always returning B3 to zero
etc.

Can someone please help
At first I thought it would be easy but now I see that It's beyond me

Thanks again
Mike from Africa
South Africa


--
=================================

Tell me and I'll forget
Show me and I'll remember
Involve me and I WILL learn

=================================