I am trying to use the DCOUNTA function, but I want my criteria ranges
to not have to be disconnected because of the way my data tables are
set up. So it there some way to make the following work?


=DCOUNTA(dbaseoftrendallyrterms,7,A17:C18,E16:E17)
|
Excel wont let this work because the
ranges are disconnected (it says I have given the function too many
arguments)....is there a way around this?

Sorry the disconnected range is the part saying "A17:C18,E16:E17" not
the labeled range (i.e. the down line is in the wrong spot)