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

=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

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

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

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