Numbers:
A1 = 2
A2 = 5
A3 = 3
A4 = 6
A5 = 2
A6 = 3
A7 = 4
A8 = ?
Looking for a formula that would allow me to count the numbers 3-5, only, and the result be displayed in cell A8, using IF and COUNT, or maybe something else.
Numbers:
A1 = 2
A2 = 5
A3 = 3
A4 = 6
A5 = 2
A6 = 3
A7 = 4
A8 = ?
Looking for a formula that would allow me to count the numbers 3-5, only, and the result be displayed in cell A8, using IF and COUNT, or maybe something else.
There's a number of solutions that would work. SUMPRODUCT or COUNTIFS would be the simplest in execution, though something convoluted could be constructed with basic functions as well.
=SUMPRODUCT((A1:A7>2)*(A1:A7<6))
=COUNTIFS(A1:A7,">2",A1:A7,"<6")
=COUNT(IF(A1:A7>2,IF(A1:A7<6,A1:A7))) -array formula
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Here's another one assuming the numbers will always be integers.
=SUM(COUNTIF(A1:A7,{3,4,5}))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks