Mr Biff,

Love to see you coercing a date with the unary operator, but could I suggest
that you use the form

=SUMPRODUCT(((register01532!$b$7:$b$401=--"2006-01-01")

it removes all ambiguites with dates re mm/dd or dd/mm formats.


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Biff" wrote in message
...
Hi!

Question is: Why did I have to use the Date function in one formula and
not
the other?

You didn't have to use the Date function. In the one formula you're
referencing a cell that holds the date.

In the below formula:

=sumproduct(((register01532!$b$7:$b$401=1/1/06)...

You have what *YOU* think is a date but Excel sees 1 divided by 1 divided
by
6.

Try it this way:

=sumproduct(((register01532!$b$7:$b$401=--"1/1/2006")

Biff

"Walter Mayes" wrote in message
...
In one of my spreadsheets I have a sumproduct formula that looks down
a
column of dates and returns 7 day totals for certain items. Works great.
The formula is, in part:
=sumproduct(((meter readings!a$4:$a$1064p$4).........

Column A contains =b4. Both columns, A and B, are formatted as dates:
I.E.
04/03/06 P4 is also formatted as a date I.E. 3-Apr-06

In another spreadsheet I was setting up a formula to get quarterly
totals. Same basic idea as the above formula. My formula is/was, in
part:

=sumproduct(((register01532!$b$7:$b$401=1/1/06)...

Column B formatted as dates. This would not work. Returned nothing but
0's.
By modifying the formula to .....=date(2006,1,1)).... it worked.

Question is: Why did I have to use the Date function in one formula
and
not the other?

Walter Mayes