I would like to do various reports from one worksheet (remaining in the same workbook). I need to count cells AF2:AF289 on another sheet that are >1.5 but <=3.0. That needs to be added to a count of cells BD2:BD289 on that same sheet that are >1.5 but <-3.0 Here is a copy of the formula that is not working. It may relay more clearly what I am trying to do.
=COUNTIF('TN''s Survey Data by Region'!AF2:AF290,">1.5")-COUNTIF('TN''s Survey Data by Region'!AF2:AF290,"<=3.0")+COUNTIF('TN''s Survey Data by Region'!BD2:BD290,">1.5")-COUNTIF('TN''s Survey Data by Region'!BD2:BD290,"<=3.0")

Obviously this is NOT working. I have attempted to use SUMIF to sum the two greater than / less than countif arrays - FAIL. I tried to do dFunctions - FAIL. SUMPRODUCT - fail. Arrays, database functions.... I'm spent. I have read Excel "help" sites until my eyes are ready to bleed and now I'm thinking I've gotten tunnel vision and cannot see the obvious. Any assistance would be greatly, greatly appreciated. I'm not a newbe to Excel (since 97) but this has definately brought that old novice feeling back again.