| 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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif Help
That will work for this cell but then another cell will be negative
"Peo Sjoblom" wrote: 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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif Help
The formula was designed for a lower limit in C2 and an upper limit in D2.
If you haven't got the data arranged that way, and you have C2 and D2 as limits that might be either way round, then replace C2 in the formula by MIN(C2,D2), and replace the original occurrence of D2 in the formula by MAX(C2,D2). -- David Biddulph "Curtis" wrote in message ... That will work for this cell but then another cell will be negative "Peo Sjoblom" wrote: Switch places between D2 and C2 "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 | |||
Linear Mode
