| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif to always get a positive number
I'm not quite sure what you're doing, but if you surround your formula with
=abs(), you'll end up with a non-negative result. =abs(countif(...)-countif(...)) OrlandoFreeman wrote: I want to countif the occurrences between a certain average result/number in my cell V66 and cero. Because my data would be changing over time, the numbers of occurences will be higher or lower. How do I combine the following to countif and always get a positive number?: - If I use my formulae =COUNTIF(V5:V64,""&V66)-COUNTIF(V5:V64,"0"), I get the correct number, but it is a negative number (e.g.-25) - If I reverse the order in the formulae above: =COUNTIF(V5:V64,"0")-COUNTIF(V5:V64,""&V66), I still get the correct number and it is positive (e.g. 25). Thank you -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountIF columnH2-H101 the number of time between ages 20-29 occurs | Excel Worksheet Functions | |||
| Force function to show positive or negative number? | Excel Worksheet Functions | |||
| Preceding a number by zeros, that is still a number | Excel Worksheet Functions | |||
| How can I get the XIRR funct to work for a positive first number? | Excel Worksheet Functions | |||
| countif number of occurences per month per year. | Excel Worksheet Functions | |||
Hybrid Mode
