Need some help with a formula.
I currently have a range of cells that have some information in each.
Columns A to AC
Column M contains a Numb 0-9
Column F contains a number as well (time displayed in days e.g. 1=24 hrs)
I have some labels such as:
0-1
1-4
4-5
5-24 and so on...
What I need is a formula for each of the labels above.
For instance: I need to count all rows where Column M contains let's say the Number 2 and where column F is =>0 but less then 1, the second label would be =>1 but <4, etc....
Is there a way to do this using a formula, or would it be faster to calculate using VBA?
Bookmarks