multiple conditions and COUNTIF
Posted by Lu Wood on January 15, 2002 12:19 PM
I was SO glad to find this forum.
I have a spreadsheet for a college project that needs to give
the number of instances cells in one column are greater than one amount but less than another.
For example my formula was: +COUNTIF(A1:A12,">5000,<10000")I also need to compute >10000 but <15000,
and so on up until 50000.
The COUNTIF function is only computing the one variable
(<) and doesn't even factor in the rest. COUNTIF seemed appropriate but doesn't appear to handle more than one criteria.
I can't locate another function Please advise...
I have 8 pages to compute formulas on and then need to build charts. I've only got a week and this has me stuck!!
Pardon the panic.