Microsoft Office Forums Help with COUNTIF

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
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
Reply With Quote
Old 05-24-2019, 02:53 PM
Alansidman's Avatar
Alansidman Alansidman is offline Help with COUNTIF Windows 10 Help with COUNTIF Office 2019
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 24
Alansidman is on a distinguished road

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

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. is not affiliated with Microsoft