Cell Ranges

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?
 
R

RagDyer

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?
 

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

Word VBA - Automatic change content of a cell in table using dropdown list 5
Help! Is this possible 2
Mail Merge Directory Conditional Page Break 0
Percentage Increase 11
Copy and shift data automaticaly 0
Trying to lookup based on a condition of two values 1
Progressive pricing 8
Index Match Max? 2

Top