Count/if/and function?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tonyalt3 - 25 Mar 2008 20:43 GMT

I would like to count how many cells only IF they contain a value
greater than 1. Is this possible?

Reply to this Message

Gord Dibben - 25 Mar 2008 20:58 GMT

=COUNT(A1:A123,">1")

Adjust range to suit.

Gord Dibben MS Excel MVP

>I would like to count how many cells only IF they contain a value
>greater than 1. Is this possible?

Reply to this Message

tonyalt3 - 25 Mar 2008 21:22 GMT

> =COUNT(A1:A123,">1")
>
[quoted text clipped - 6 lines]
>
> - Show quoted text -

Gord,
This is still counting cells w/zeros in it, any other thoughts?

Reply to this Message

Pete_UK - 25 Mar 2008 21:00 GMT

If your cells are in column A, then try this:

=COUNTIF(A:A,">1")

Hope this helps.

Pete

> I would like to count how many cells only IF they contain a value
> greater than 1. Is this possible?

Reply to this Message

tonyalt3 - 25 Mar 2008 21:22 GMT

> If your cells are in column A, then try this:
>
[quoted text clipped - 8 lines]
>
> - Show quoted text -

Thanks Pete, but I need to make sure it does NOT count any cells w/
zeros in it. This seems to still count them. Any other suggestions?

Reply to this Message

Rick Rothstein (MVP - VB) - 25 Mar 2008 22:26 GMT

> > > I would like to count how many cells only IF they contain a value
> > > greater than 1. Is this possible?- Hide quoted text -
[quoted text clipped - 9 lines]
> Thanks Pete, but I need to make sure it does NOT count any cells w/
> zeros in it. This seems to still count them. Any other suggestions?

Did you try it? It works fine on my system.

Note, Pete is suggesting COUNTIF, not COUNT.

Rick

Reply to this Message

Jarek Kujawa - 25 Mar 2008 21:08 GMT

=SUM(IF((ISNUMBER(A1:A10)*(A1:A10>1),1,0)

insert with Ctrl+Shift+Enter

Reply to this Message