You can use =SUMPRODUCT((B1:B20000="ABC Company")*(Q1:Q20000=DATEVALUE("1
April 2008"))*(Q1:Q20000<=DATEVALUE("30 April 2008"))*(L1:L20000))

Andrea Jones
www.stratatraining.co.uk

"MadWoman" wrote:

The formula returns a 0. I need it to return $38,241.51

=SUMPRODUCT((Data!B1:B20000="ABC
Company")*(Data!Q1:Q20000="Apr-08")*(L1:L20000))The formula below returns a
0. I need it to return $38,241.51.

Column B = Company Name
Column Q = MM/YY
Column L = Subtotal dollar amount

What am I missing and how can this be corrected to return the correct value.