Excel Question #46

Kevy Baby · 12-12-2008, 07:16 PM

Rather than starting yet another Excel help thread, I drudged up an old one.

If I have a series of cells that are calculation results, is there a way to get a count of just the cells with a result value of greater than zero (or conversely, those cells with result value of zero)

I tried using DCountA, but that didn't work (unless I wrote the formula incorrectly).

Any ideas

ETA: I found my own answer: a CountIF function

12-12-2008, 07:16 PM	#8
Kevy Baby Chowder Head Join Date: Jan 2005 Location: Yes Posts: 18,500	Rather than starting yet another Excel help thread, I drudged up an old one. If I have a series of cells that are calculation results, is there a way to get a count of just the cells with a result value of greater than zero (or conversely, those cells with result value of zero) I tried using DCountA, but that didn't work (unless I wrote the formula incorrectly). Any ideas ETA: I found my own answer: a CountIF function __________________ The thing about quotes on the internet is that you cannot verify their validity. - Abraham Lincoln
	Submit to Quotes

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode