Count Formula if $$ is between certain $$ Values

Susan Swisher

Hi.. I need to write the following formula to return specific counts (see below); basically, look in the BANK column and COUNT the number of items that are in the $$ range(s). I am using Sheet Summary to populate those "Counts".

=COUNT([Bank]:[Bank], >????)

=COUNT([Bank]:[Bank], <>????)

Thank you.

Mark Safran

Hey Susan,

You'll need a unique formula for each row in your Count column in order to define the range constraints. Give these a try:

$0M :

=COUNTIFS(Bank:Bank, =0)

$0.01M - $0.50M :

=COUNTIFS(Bank:Bank, >0, Bank:Bank, <=500000)

$0.51M - $0.99M :

=COUNTIFS(Bank:Bank, >500000, Bank:Bank, <1000000)

$1.00M - $1.49M :

=COUNTIFS(Bank:Bank, >=1000000, Bank:Bank, <1500000)

$1.50M - $2.00M :

=COUNTIFS(Bank:Bank, >=1500000)

-MS

Mark Safran

Hey Susan,

You'll need a unique formula for each row in your Count column in order to define the range constraints. Give these a try:

$0M :

=COUNTIFS(Bank:Bank, =0)

$0.01M - $0.50M :

=COUNTIFS(Bank:Bank, >0, Bank:Bank, <=500000)

$0.51M - $0.99M :

=COUNTIFS(Bank:Bank, >500000, Bank:Bank, <1000000)

$1.00M - $1.49M :

=COUNTIFS(Bank:Bank, >=1000000, Bank:Bank, <1500000)

$1.50M - $2.00M :

=COUNTIFS(Bank:Bank, >=1500000)

-MS