Counting

  • Thread starter Thread starter BIGMIKE
  • Start date Start date
B

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!
 
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%
 
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.
 
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)
 
If you used my suggested formulas, enter this in F1:

=D1/SUM(D$1:D$4)

And copy down to F4.

Format F1 to F4 as a Percent.
 
Back
Top