Count Formula if $$ is between certain $$ Values


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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!