Seems that Excel 2003 doesn't have the nice little COUNTIFS function that I have in my Excel 2007. What to do, what to do, what to do ...
Well, it'd be nice to install Office 07, but in the interim, how about a bit of VBA?
We'll call it RANGEDCOUNT, and it will accept a range of data, and a string being the criteria. The criteria can be
- a single value preceded by an operation (>, >=, =, <=, <, #), or
- a range of values, the upper and lower bounds separated by a dash.