You can actuall emove the "--" in the last part of the formula.

=SUMPRODUCT(--(Sheet2!B1:B1000=D2),--(Sheet2!B1:B1000<C2),(Sheet2!H1:H1000))However, I don't think that is the cause of the result.What is the cell format for column H and cells C2 and D2?Are all of them in Date formats?--"Sarah (OGI)" wrote in ... Paul I've amended my formula slightly (and included another criteria). I'm now just getting a zero, despite knowing that there are figures greater thanzero in the sum_range. Any ideas? "PCLIVE" wrote: You cannot use entire columns with SUMPRODUCT. Specify your range.=SUMPRODUCT(--(Sheet2!B1:B1000=D2),--(Sheet2!B1:B1000<C2),--(Sheet2!H1:H1000)) HTH, Paul -- "Sarah (OGI)" wrote in message ... I have entered the following expression: =SUMPRODUCT(--(Sheet2!B:B=D2),--(Sheet2!B:B<C2),--(Sheet2!H:H)) D2 shows 01/09/2005 and C2 shows 01/09/2006. I have some data on Sheet 2 with data listed as follows: Date/Class Code/Company Name/Amount I would like to sum the amounts where the dates are between D2 and C2. I'm getting a result of #NUM! Any suggestions? I'm not sure I'm using the right function, but I'm asking for multiple criteria, i.e. where the date is = one date but < another date.