Database Count function.

  • Thread starter Thread starter Chip
  • Start date Start date
C

Chip

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)
 
Back
Top