| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Help
cell c2 = 80%
Column of data is c5:c27 I need to calculate the % of sales greater than the value in cell c2. thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif Help
This formula returns the percentage of values
in C5:C27 that are greater than the value in C2. Note: it divides by the count of numeric values in C5:C27: =COUNTIF(C5:C27,""&C2)/COUNT(C5:C27) Format the result as Percent Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Curtis" wrote in message ... cell c2 = 80% Column of data is c5:c27 I need to calculate the % of sales greater than the value in cell c2. thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif Help
Thanks that worked
I need to now determine the % that fails within a range says between the value in c2 and the value in d2 Thanks "Ron Coderre" wrote: This formula returns the percentage of values in C5:C27 that are greater than the value in C2. Note: it divides by the count of numeric values in C5:C27: =COUNTIF(C5:C27,""&C2)/COUNT(C5:C27) Format the result as Percent Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Curtis" wrote in message ... cell c2 = 80% Column of data is c5:c27 I need to calculate the % of sales greater than the value in cell c2. thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif Help
Lastly the formula needs to exclde blank cell ( however the cells do contain
a formula) "Curtis" wrote: Thanks that worked I need to now determine the % that fails within a range says between the value in c2 and the value in d2 Thanks "Ron Coderre" wrote: This formula returns the percentage of values in C5:C27 that are greater than the value in C2. Note: it divides by the count of numeric values in C5:C27: =COUNTIF(C5:C27,""&C2)/COUNT(C5:C27) Format the result as Percent Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Curtis" wrote in message ... cell c2 = 80% Column of data is c5:c27 I need to calculate the % of sales greater than the value in cell c2. thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif Help
=(COUNTIF(C5:C27,""&C2)-COUNTIF(C5:C27,"="&D2))/COUNT(C5:C27)
-- Best Regards, Luke M "Curtis" wrote: Thanks that worked I need to now determine the % that fails within a range says between the value in c2 and the value in d2 Thanks "Ron Coderre" wrote: This formula returns the percentage of values in C5:C27 that are greater than the value in C2. Note: it divides by the count of numeric values in C5:C27: =COUNTIF(C5:C27,""&C2)/COUNT(C5:C27) Format the result as Percent Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Curtis" wrote in message ... cell c2 = 80% Column of data is c5:c27 I need to calculate the % of sales greater than the value in cell c2. thanks |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif Help
if c2= 9% and d2=8% it returns a negative value?
"Luke M" wrote: =(COUNTIF(C5:C27,""&C2)-COUNTIF(C5:C27,"="&D2))/COUNT(C5:C27) -- Best Regards, Luke M "Curtis" wrote: Thanks that worked I need to now determine the % that fails within a range says between the value in c2 and the value in d2 Thanks "Ron Coderre" wrote: This formula returns the percentage of values in C5:C27 that are greater than the value in C2. Note: it divides by the count of numeric values in C5:C27: =COUNTIF(C5:C27,""&C2)/COUNT(C5:C27) Format the result as Percent Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Curtis" wrote in message ... cell c2 = 80% Column of data is c5:c27 I need to calculate the % of sales greater than the value in cell c2. thanks |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif Help
Switch places between D2 and C2
-- Regards, Peo Sjoblom "Curtis" wrote in message ... if c2= 9% and d2=8% it returns a negative value? "Luke M" wrote: =(COUNTIF(C5:C27,""&C2)-COUNTIF(C5:C27,"="&D2))/COUNT(C5:C27) -- Best Regards, Luke M "Curtis" wrote: Thanks that worked I need to now determine the % that fails within a range says between the value in c2 and the value in d2 Thanks "Ron Coderre" wrote: This formula returns the percentage of values in C5:C27 that are greater than the value in C2. Note: it divides by the count of numeric values in C5:C27: =COUNTIF(C5:C27,""&C2)/COUNT(C5:C27) Format the result as Percent Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Curtis" wrote in message ... cell c2 = 80% Column of data is c5:c27 I need to calculate the % of sales greater than the value in cell c2. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =COUNTIF | Excel Discussion (Misc queries) | |||
| How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
| edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Hybrid Mode
