Formula for ratio

[rajeshn_in]

Hi Friends,

rows as below

23630
23650
23580
23560
27680
27690
27660
25030

I want to know how many rows are Less-than 23700 and how many rows are Grater than 23700

Thank you.

[JohnTopley]

=COUNTIF($A$1:$A$8," < 23700")

=COUNTIF($A$1:$A$8," > 23700")

remove blanks in " > 23700" (added as forum firewall does not like " > " with no blanks)

[AliGW]

Ah, that's why I couldn't post my reply! Thanks, John.

[rajeshn_in]

Please see attachment, I want to minus 1 TOTAL Counting ......... F13, G13 (I put formula upto 200 rows, because some time rows can increase or decrease

If total came 0, than no need to come -1

[rajeshn_in]

Other wise we can create formulas like

1) Less than 23700
2) Between 23701 to 27700

[AliGW]

Please don't send private messages to other forum members prompting them to answer your thread - that is not what the private messaging system is for. Keep everything regarding this query in this one thread, please. You will have to be patient: those who help here are doing so voluntarily in their free time.

Thank you.

[JohnTopley]

=COUNTIFS($F$5:$F$200," > 23700",$F$5:$F$200," <= 27700")

As before, remove blanks

[rajeshn_in]

Thank you John.