Thread
:
Counting
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett