| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count numbers and non numbers(conditional values)
It works for some of the data, however I have values of <0.5 that get
included as part of this formula. Thank you for the quick response. "Gary''s Student" wrote: =COUNTIF(A1:G1,""&3.7)+COUNTA(A1:G1)-COUNT(A1:G1) -- Gary''s Student - gsnu200785 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I count numbers without including the repeated values? | Excel Discussion (Misc queries) | |||
| can numbers be assigned to values, replacing values for numbers | Excel Discussion (Misc queries) | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
| formula to count numbers of certain values | Excel Worksheet Functions | |||
Hybrid Mode
