I have 1 column with numbers that range from 1.00 to -5.00 with about 160 rows. I want to count the number of cells that contain 1.00 to 0.00 and total in a cell at bottom of page, another that totals -0.01 to 1.00, another that totals -1.01 to -2.00 and so on.
Is there a formula to do this, maybe even highlight cells in each group with a cell color.
Any assistance appreciated.
Is there a formula to do this, maybe even highlight cells in each group with a cell color.
Any assistance appreciated.