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