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 truncate two databases to somehow combine A:D and K just for
the function?

Thanks,
RiotLoadTime


--
RiotLoadTime
------------------------------------------------------------------------
RiotLoadTime's Profile: http://www.excelforum.com/member.php...o&userid=35956
View this thread: http://www.excelforum.com/showthread...hreadid=557470