Is it possible to have criteria for a Dbase function not directly above and below each other? This would be really useful, as I want to hook up my table with the Dbase formula, and I would be able to drag the formula instead of manually copying and pasting. My Dbase criteria heading is 'Team' and the criteria can be 8 different teams. I want to be able to have 'Team' in cell A5 and the teams Im specifying in cells A10 throught A18
So the formula would look like =Dcounta($C$2:$H$100,4,$A$5,$A$10)
So the formula would look like =Dcounta($C$2:$H$100,4,$A$5,$A$10)
