Thread: Counting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] BIGMIKE@HOTMAIL.ORG is offline
external usenet poster
 
Posts: 2
Default 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!