If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|