Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting And Countif | Excel Discussion (Misc queries) | |||
Use CountIF with conditional formulas | Excel Worksheet Functions | |||
Nested Countif | Excel Worksheet Functions | |||
Countif Function -Nested | Excel Discussion (Misc queries) | |||
Countif and Conditional Formatting | Excel Worksheet Functions |