Alpha/Numerical numbers

R

rhani111

Hi all,

I am trying to match data in a formula and the cell contains an alph
numeric value....with spaces...ughhhh

e.g. VK 1234 RAM which is in A2

What I need to retrieve is lookup the value in A2:A6, find exact matc
to that value and ADD the totals of each value...

e.g.

A B C
VK 1234 RAM 18/07/06 2
VK 1234 RAM 20/07/06 5
VK 5678 RAM 18/07/06 3
VK 1234 RAM 18/07/06 5

RESULT I'm after would be

VK 1234 RAM 10
VK 5678 RAM 5

Can anyone help me
 
R

rhani111

OMG....that is almost perfect....i say ALMOST because I need the VK 123
RAM in one column and the total (10) in the next column....

Please please help remove the text from the sum result......

Tar muchly
Sand
 
R

rhani111

okies.....i had worked that one out myself after i posted thankx.....

Due to there being more than one sheet with the same item codes et
(for each different site that I record for) how do i stop it listin
the duplicates, but only list it once with a total for all
 
Top