=SUMPRODUCT((Data!B1:B20000="Access
Nurses")*(Data!Q1:Q20000="Apr-08"),(L1:L20000))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"MadWoman" escreveu:

I tried the formula below in my database and I get a 0 as an answer.
=SUMPRODUCT((Data!B1:B20000="Access
Nurses")*(Data!Q1:Q20000="Apr-08")*(L1:L20000))

Can someone tell me what I'm doing wrong and how to correct?

Column B contains different vendor names, column Q contains the month of the
transaction and colum L contains a subtotaled dollar amount.