Database Count function.

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?
 
C

Chip

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Select text from a point given to a specific word 2
Database Functions and Hyperlinks 0
Copying a range 1
Count records where date is within the last week 1
Page numbering with Merged Document and IF statements 1
Problem using multiple criteria to get a count 1
WORD VBA Search and switch to advanced ... 1
Using dcount function within user-defined worksheet function 3

Top