Counting prime numbers in an interval with Excel

Scenario
Suppose you are asked to find out number of prime numbers in an interval.


Suppose lower limit of a range is entered in cell C2 and upper limit in cell C3.
Solution
1. Press CTRL + F3 to open name manager
2. Click "New"
3. In "Name", type rng
4. In "Refers to: " box, enter =ROW(INDIRECT(Sheet1!$C$2&":"&Sheet1!$C$3))



5. Click OK
6. Click Close

In cell E5, enter the following formula :


Hit CTRL + SHIFT + ENTER to confirm this formula as an array formula. If done correctly, Excel will automatically place curly braces {...} around the formula.

Download the workbook

Related Post : 
Generating prime numbers in an interval with Excel
Check if a number is prime with Excel

About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has close to 7 years of experience in data science and predictive modeling. During his tenure, he has worked with global clients in various domains like retail and commercial banking, Telecom, HR and Automotive.


While I love having friends who agree, I only learn from those who don't.

Let's Get Connected: Email | LinkedIn

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*

Related Posts:

0 Response to "Counting prime numbers in an interval with Excel"

Post a Comment

Next → ← Prev