How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask technicalcat Your Own Question
technicalcat
technicalcat, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 1945
Experience:  20yrs experience with advanced degrees
65369237
Type Your Microsoft Office Question Here...
technicalcat is online now
A new question is answered every 9 seconds

I have thousands of numbers on a spreadsheet (kind of) i

Customer Question

i have thousands of numbers on a spreadsheet (kind of) i want excel to find how many of each number there are
Submitted: 7 months ago.
Category: Microsoft Office
Expert:  technicalcat replied 7 months ago.

Hello ER, and thank you for using this service.

There are a few different ways to do this, but one of the easiest would be the SUM function in the cell you want the total count result to appear.

Use this formula

=SUM(IF(range=number,1,0))

where range is the range that you want to search, and number is ***** number that you want to count.

Customer: replied 7 months ago.
if i want to find all the number 20 in the cell:
=sum(if(range=20)
Expert:  technicalcat replied 7 months ago.

Close, but you'll need to put in a range. Example:

=SUM(IF(A1:A10=20,1,0))

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

IMPORTANT

Please remember to rate my time and help to you before you go. I continue to help before and after rating, and strive for excellent service. A positive rating is the only way I receive any credit for helping you today. Thank You.

Customer: replied 7 months ago.
Sorry, I m on the road. As soon as I have a chance I will contact you.
Expert:  technicalcat replied 7 months ago.

ok.

IMPORTANT

Please remember to rate my time and help to you before you go. I continue to help before and after rating, and strive for excellent service. A positive rating is the only way I receive any credit for helping you today. Thank You.