Excel Problem....

[John H]

Hi,

Can anybody help me, I have a spreadsheet in the following format

A B C
Date Our Ref Type
09/11/2007 1233456 REEL06
09/11/2007 4353464 REEL01
09/11/2007 4646346 REEL06

etc....

I would like the function to count the instances of each type and
report this in a separate column, in this case REEL = 2. Also each
type has a value assigned to it, i.e 0.5, so the database will then
have to check the value against another worksheet and multiply this
value by the number counted for each item

So in this example,. the desired output will be (asuming the value for
REEL06 is 1.00 per item, and REEL01 is 0.50):

D E F
Result_Type Quantity Total Price
REEL06 2 2.00
REEL01 1 0.50



I hope this makes sense.

 

[Bernard Liengme]

In E2: =COUNTIF(C:C,D2) and copy down the column
For the second part use VLOOKUP but you have not given us enough info to
tell you exactly how.
best wishes