Count when column A = "Columbia" and column B = "Open" and the value in column C <=30 >60

I am making report based on the criteria being met in another worksheet. I have been using SUMPRODUCT to get the counts.

I can get this formula to work, when the value is less than 30
=SUMPRODUCT(('Query Listing'!C:C="01-Columbia")*('Query Listing'!O:O="Query Resolution")*('Query Listing'!K:K<30))


HOWEVER, I can not get the formula to work for range, such greater than or equal to 30 but less than 60
=SUMPRODUCT(('Query Listing'!C:C="01-Columbia")*('Query Listing'!O:O="Query Resolution")*('Query Listing'!K:K>=30<60))


FYI, in the Query Listing worksheet (tab) the values in column K are populated using =IF(M5>0,M5-L5,TODAY()-L5), which is the count of days opened



http://www.excelforum.com/images/smi...s/rolleyes.gif