|
|
#1
05-24-2019, 01:46 PM
|
|||
|
|||
Help with COUNTIF
I have a column where rows 5-35 contain either a $-amount, 0, or n/a... I want to know how many rows contain $-amount. Any suggestions as to the best way to do that?
Thank you in advance Janice 
|
|
#2
05-24-2019, 02:53 PM
|
||||
|
||||
|
Assume data in Column C then =COUNTIF(C5:C35,">0")
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Countif returns 0 value
|
janielsean | Excel | 4 | 02-08-2017 08:56 AM |
| Help with IF and COUNTIF functions | jester296 | Excel | 1 | 05-13-2015 09:09 AM |
| Countif statements | Alaska1 | Excel | 5 | 02-05-2015 07:55 PM |
| Countif | hockeytown | Excel | 3 | 01-05-2013 08:06 AM |
|
Countif with 2 criteria
|
ibrahimaa | Excel | 3 | 05-23-2011 11:23 AM |
Windows 7 32bit 
Office 2013
Linear Mode
