How to calculate number of occurencies of a specific number number

S

Stefan

Hi,
I´m trying to calculate number of occurencies of a specific number, I´m
using data from different sheets
Formula:
=NUMBER.IF('sheet2'!E10:S10;">=E5") --error
NUMBER.IF('sheet2'!E10:S10;>=E5) -- error

=NUMBER.IF('sheet2'!E10:S10;E5) -- Correct but not what I´m looking for,
this give me the answer of number of occurencies of the number 3. I´m looking
for 3 and above.

E5 represent the number, for example 3 and higher

BR
 
S

Stefi

Sorry, adjust my test range:
=COUNTIF('sheet2'!E10:S10,">="&E5)
Stefi

„Stefi†ezt írta:
 
S

Stefan

Thanks, I´ve wasted a couple of hours trying to solve it my self!!

"Stefi" skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting multiple criteria using SUMPRODUCT and getting #VALUE err 1
3d Formula Verification Question 2
Formula for finding Date difference between 2 dates 4
IF-based SUMPRODUCT criteria 2
Difficulty with Sum+IF Function 10
SUMPRODUCT help needed 4
Time, & Ceiling? 3
Calculate data from different sheets 4

Top