#1
|
|||
|
|||
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
|
||||
|
||||
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 |