Results 1 to 5 of 5

DCOUNT for non-contiguous columns

Threaded View

  1. #1
    Registered User
    Join Date
    06-30-2006
    Posts
    18

    DCOUNT for non-contiguous columns

    I have a database with multiple-cell headers (descriptors like "1 hour" and "2 hour") in the first row, under which I have cell-specific headers (like "blood pressure," "temperature") in the second row, and data in the rest of the rows. I need to count all the numbers in A3:A200 where the corresponding B, C, D, and K values (i.e. the B,C,D, and K values in the same row) are equal to zero.

    It'd be nice if I could define my database for the function(i.e. "DCOUNT(database,field, criteria)") to be A2:K200, have the field=1, and make a criteria array with the first row being the headers for B,C,D, and K, and the second row being 0. Unfortunately, I can't do that because G2 actually has the same heading as K2 (they're both blood pressure, they're just at two different times, as shown by them being under A1 and B1 respectively).

    Is there any way for me to make the database have just columns A, B, C, D, and K without rearranging them or modifying their headers? Is there anyway to concatenate two databases to somehow combine A:D and K just for the function?

    Thanks,
    RiotLoadTime
    Last edited by RiotLoadTime; 06-30-2006 at 04:28 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1