Thank you. Works for AM only, though. PM times appear to be ignored. Help!!!

NWO



"Bernie Deitrick" wrote:

NWO,

=SUM((B$1:B$100=DATEVALUE("3/10/2007"))*((C$1:C$100)=TIMEVALUE("6:00 AM")))

HTH,
Bernie
MS Excel MVP


"NWO" wrote in message
...
Hello.

I have two columns of data - Column B is dates formatted as date (i.e.
3/10/2007), and column C is times formatted as time (i.e. 6:00 AM). Problem
I'm having is that when I run an array to search for values that meet my
criteria in both columns, I get 0, where I know that there are matching
values. I use the following array formula:
{=SUM((B$1:B$100="3/10/2007")*(C$1:C$100="6:00 AM"))}.

There are 7 entires that meet this particular criteria, however, the formula
gives me 0. ANy assitance with tis is appreciated.

Note that when I run seperate COUNTIF statements in each column, I get the
desired result, but only for the values in one column - I did this as a test
to ascertain if I was using the proper syntax.

Thank you.

NWO