Microsoft Office Forums Help with COUNTIF

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-24-2019, 01:46 PM
MaineLady MaineLady is offline Help with COUNTIF Windows 7 32bit Help with COUNTIF Office 2013
Advanced Beginner
Help with COUNTIF
 
Join Date: Sep 2014
Posts: 40
MaineLady is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 05-24-2019, 02:53 PM
Alansidman's Avatar
Alansidman Alansidman is offline Help with COUNTIF Windows 10 Help with COUNTIF Office 2019
Novice
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 24
Alansidman is on a distinguished road
Default

Assume data in Column C then =COUNTIF(C5:C35,">0")
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with COUNTIF 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
Help with COUNTIF Countif with 2 criteria ibrahimaa Excel 3 05-23-2011 11:23 AM


All times are GMT -7. The time now is 10:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft