Counting

[BIGMIKE]

I'm a beginner with Excel so this may be a simple problem. I'm trying to
count various items to give me a total of how many I have of each type that
I have purchased over the years,

Example:

Type: Value
Dime $10.
Penny $25.
Dime $20.
Half $10.
Penny $15.
Penny $15.
Dime $10.
Half $50.
Nickel $5.00

Number of Dimes 3 Total Value $40.
Number of Pennies 3 Total Value $55.
Numer of Halfs 2 Total Value $60.
Number of Niclels 1 Total Value $5.

I want to count each item, Dime, Penny, Half and Nickels to show me home
many of each I have and the total value of each catagory.

Thank you in advance for your help!

 

[Don Guillett]

Look in the HELP index for COUNTIF

 

[BIGMIKE]

I forgot to ask that I need to know what percentage of each I havealso.

Thanks again.

Penny 33%
Nickel 5%
Dime 25%
Half 1%

 

[Ragdyer]

Say your original datalist is in A1 to B10, with labels in Row1.

Enter a unique list of your coins, starting in say, C1 to C4, matching your
example.

In D1 enter:

=COUNTIF(A$2:A$10,C1)

And, in E1 enter:

=SUMIF(A$2:A$10,C1,B$2:B$10)

NOW, select *both* D1 and E1, and drag down to copy to Row 4.

This should give you what you're looking for.

 

[JMB]

Say the countif function that has already been suggested is in D1 and your
data is in A1:B10 (first row is a header), you could use:

=D1/COUNTA(A$2:A$10)

 

[Ragdyer]

If you used my suggested formulas, enter this in F1:

=D1/SUM(D$1$4)

And copy down to F4.

Format F1 to F4 as a Percent.