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?
 
Back
Top