ExcelBanter - Database Count function.

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Database Count function. (https://www.excelbanter.com/excel-programming/323785-database-count-function.html)

Chip[_3_]

Database Count function.

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?

Chip[_3_]

Database Count function.

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)

All times are GMT +1. The time now is 05:07 PM.