Related:
- Excel count exclude zero and blank
- Count if not zero - Best answers
- Excel count exclude zero - Best answers
- Excel count conditional formatting color cells - Forum - Excel
- Excel count names in list - How-To - Excel
- Excel - Counting number of days between two entries - How-To - Excel
- Excel - Count 2 values in one column and 1 value in other - How-To - Excel
- Excel count in french - How-To - Excel
2 replies
doublewitt
- Posts
- 14
- Registration date
- Sunday April 27, 2014
- Status
- Member
- Last seen
- September 29, 2014
Oh great - thanks
that works fine
that works fine
aquarelle
- Posts
- 7098
- Registration date
- Saturday April 7, 2007
- Status
- Moderator
- Last seen
- June 10, 2021
Hello
You should use COUNTIF(range,criteria)
If your data are in range A2 to A33, to exclude zero value, you can use this formula :
=COUNTIF(A2:A33,"<>0")
Regards
You should use COUNTIF(range,criteria)
If your data are in range A2 to A33, to exclude zero value, you can use this formula :
=COUNTIF(A2:A33,"<>0")
Regards
