ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Countif Help (https://www.excelbanter.com/excel-worksheet-functions/168482-countif-help.html)

Curtis
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

Ron Coderre
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

Curtis
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

Curtis
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

Luke M
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

Curtis
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

Peo Sjoblom
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

Curtis
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

David Biddulph[_2_]
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


All times are GMT +1. The time now is 05:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com