I'd use:

=SUMPRODUCT(--(A2:A12=date(2005,6,1)),--(C21:C12="Bikes"),D2:D12)

Just to remove any ambiguity between mdy and dmy dates.

Matt wrote:

Nope, that didn't work. Still came up with zero. Here's the sample table
I'm trying to use before I impliment this on my real table:

A B C D
Date Name Product Qty
6/1/2005 Jason bikes 6
6/2/2005 Randy cars 8
6/3/2005 Randy bikes 9
6/1/2005 Daniel cars 8
6/2/2005 Matt cars 231
6/3/2005 Daniel bikes 654
6/1/2005 Jason cars 654
6/2/2005 Daniel cars 65

Here's my formula:
=SUMPRODUCT(--(A2:A12="6/1/2005"),--(C21:C12="Bikes"),D2:D12)

There's something with the date I know. Does it need to be in "" ? I've
tried both ways and it doesn't work. I even tried changing it from a date
format to a number (38504) that didn't work either.

"Domenic" wrote:

In article ,
"Matt" wrote:

Thanks, that took away the #num error, but now it's not totaling. It has to
do something with the date because when I run the formula with two text
columns it works, but when I change it to one text column and then also
looking for a date, it comes out with a zero amount.

Make sure that the format for the date column matches the cell format
for its criterion. Try the following...

1) Select an empty cell

2) Edit Copy

3) Select the date column

4) Edit Paste Special Add Ok

Does this help?


--

Dave Peterson