#### DanteAmor

##### Well-known Member

- Joined
- Dec 3, 2018

- Messages
- 10,182

- Office Version
- 2007

- Platform
- Windows

This

=COUNTIF(A2:A9,">0")

Or this

=SUMPRODUCT(COUNTIF(A2:A9,">0"))

---

Or array formula:

{=COUNT(IF(VALUE(A2:A9)>0,1,0))}

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

=COUNTIF(A2:A9,">0")

Or this

=SUMPRODUCT(COUNTIF(A2:A9,">0"))

---

Or array formula:

{=COUNT(IF(VALUE(A2:A9)>0,1,0))}

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

Last edited: