Count/if/and function?

[tonyalt3]

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

 

[Gord Dibben]

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

Adjust range to suit.


Gord Dibben MS Excel MVP

 

[Pete_UK]

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

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

Hope this helps.

Pete

 

[Jarek Kujawa]

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

insert with Ctrl+Shift+Enter

 

[tonyalt3]

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

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

Hope this helps.

Pete



- 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?

 

[tonyalt3]

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

Adjust range to suit.

Gord Dibben  MS Excel MVP





- Show quoted text -

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

 

[Rick Rothstein \(MVP - VB\)]

I would like to count how many cells only IF they contain a value

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