T
tonyalt3
I would like to count how many cells only IF they contain a value
greater than 1. Is this possible?
greater than 1. Is this possible?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
=COUNT(A1:A123,">1")
Adjust range to suit.
Gord Dibben MS Excel MVP
Adjust range to suit.
Gord Dibben MS Excel MVP
P
Pete_UK
If your cells are in column A, then try this:
=COUNTIF(A:A,">1")
Hope this helps.
Pete
=COUNTIF(A:A,">1")
Hope this helps.
Pete
J
Jarek Kujawa
=SUM(IF((ISNUMBER(A1:A10)*(A1:A10>1),1,0)
insert with Ctrl+Shift+Enter
insert with Ctrl+Shift+Enter
T
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?
T
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?
R
Rick Rothstein \(MVP - VB\)
I would like to count how many cells only IF they contain a value
Did you try it? It works fine on my system.
Note, Pete is suggesting COUNTIF, not COUNT.
Rick
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