Counting
 

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!

Counting
 

Look in the HELP index for COUNTIF

--
Don Guillett
SalesAid Software

wrote in message
...
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!

Counting
 

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%

Counting
 

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

wrote in message
...
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!

Counting
 

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)


" wrote:

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%

Counting
 

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
wrote in message
...
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%