Originally Posted by
oneyejack
I found a function that works great for what I need to do, in Excell 2007, but most of the pcs at my work have Excel 2003.
What I need to do is compare each cell in two columns and if more than one critera is met, I need it to be counted. For example if a tech is a "cct3" and has between 111 points and 125 points, count him.
Below is the formula from 2007 that works perfectly
=COUNTIFS(C115:C123,"cct3",M115:M123,">110",M115:M123,"<126")
This will not work for 2003 (no countifs), any ideas for a formula that might be just as funcional?
Bookmarks