Counting prime numbers in an interval with Excel

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.
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 over 7 years of experience in data science and predictive modeling. During his tenure, he has worked with global clients in various domains like banking, Telecom, HR and Health Insurance.

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