Counting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BIGMIKE@HOTMAIL.ORG - 17 Jun 2007 16:36 GMT

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!

Reply to this Message

Don Guillett - 17 Jun 2007 16:49 GMT

Look in the HELP index for COUNTIF

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> 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
[quoted text clipped - 23 lines]
>
> Thank you in advance for your help!

Reply to this Message

BIGMIKE@HOTMAIL.ORG - 17 Jun 2007 16:51 GMT

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%

Reply to this Message

JMB - 17 Jun 2007 17:29 GMT

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)

> I forgot to ask that I need to know what percentage of each I havealso.
>
[quoted text clipped - 4 lines]
> Dime 25%
> Half 1%

Reply to this Message

Ragdyer - 17 Jun 2007 17:35 GMT

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.

Signature

HTH,

RD

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

> I forgot to ask that I need to know what percentage of each I havealso.
>
[quoted text clipped - 4 lines]
> Dime 25%
> Half 1%

Reply to this Message

Ragdyer - 17 Jun 2007 16:57 GMT

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.

Signature

> 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
[quoted text clipped - 22 lines]
>
> Thank you in advance for your help!

Reply to this Message