How to calculate number of occurencies of a specific number nu
You are welcome! Thanks for the feedback!
Stefi
€žStefan€ť ezt Ă*rta:
Thanks, I´ve wasted a couple of hours trying to solve it my self!!
"Stefi" skrev:
Sorry, adjust my test range:
=COUNTIF('sheet2'!E10:S10,"="&E5)
Stefi
€žStefi€ť ezt Ă*rta:
=COUNTIF(E10:F17,"="&E5)
Regards,
Stefi
€žStefan€ť ezt Ă*rta:
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
|