Cell Ranges

  • Thread starter Thread starter HELP!!!!!!!
  • Start date Start date
H

HELP!!!!!!!

If I have 20 rows of prices in column A and some of the
prices are repeated, is there a function or formula that
I can enter so that it will tell me how many entries
there is for price a, price b, price c, etc?
 
Enter the price you're looking to count in B1,
And try this formula:

=COUNTIF(A1:A20,B1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


If I have 20 rows of prices in column A and some of the
prices are repeated, is there a function or formula that
I can enter so that it will tell me how many entries
there is for price a, price b, price c, etc?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sliding scale for Mark Up 0
Help! Is this possible 2
Data Range with more than value 7
New printer recommendations 2
What type of "lookup" 3
Percentage Increase 13
Trying to lookup based on a condition of two values 1
Excel Lookup 1

Back
Top