Countif Problem

I am trying count count the number of occurances of a value = or > than
(E7+2) but cannot workout the syntax. Can anybody kindly point me in the
right direction?

=COUNTIF(E13:E15,(E7+2))

Mark

Hi

=COUNTIF(E13:E15,">=" & (E7+2))

Arvi Laanemets


"Mark W" <mark.wilby@ntlworld.com> wrote in message
news:I592g.43414$8o.42188@newsfe6-win.ntli.net...
> I am trying count count the number of occurances of a value = or > than
> (E7+2) but cannot workout the syntax. Can anybody kindly point me in the
> right direction?
>
> =COUNTIF(E13:E15,(E7+2))
>
> Mark
>
>

Great stuff thanks Arvi

Mark


"Arvi Laanemets" <arvilaanemets@hot.ee> wrote in message
news:exN$zPXZGHA.3880@TK2MSFTNGP04.phx.gbl...
> Hi
>
> =COUNTIF(E13:E15,">=" & (E7+2))
>
> Arvi Laanemets
>
>
> "Mark W" <mark.wilby@ntlworld.com> wrote in message
> news:I592g.43414$8o.42188@newsfe6-win.ntli.net...
> > I am trying count count the number of occurances of a value = or > than
> > (E7+2) but cannot workout the syntax. Can anybody kindly point me in the
> > right direction?
> >
> > =COUNTIF(E13:E15,(E7+2))
> >
> > Mark
> >
> >
>
>