Roger: Thanks for taking the time to help me with this. I could still use
your help if you are willing. I've been thinking about it and have other
questions. I'm using SUMPRODUCT in other spreadsheets and it works well
for, of all things, COUNTING. That said, I don't understand how SUMPRODUCT
will sum up the Subtotaled $$ Figures in Column L.

I'm trying to get a formula together that if the two conditions are met,
that the COLUMN L value returned is the SUM of the two conditions, not a
count. I've been dinking w/ the formula editor & have changed Columns B & Q
to Text and made all my addition/multiplacation fields in the same format.

PS. I'm using Excel 2002.
Thanks again for your help and look forward to hearing from you.
Lost in New Mexico,
Madelyn.

"Roger Govier" wrote:

Hi

I missed a closing parenthesis in my formula.
It should have read
=SUMPRODUCT((Data!B1:B20000="ABC Company")*
(TEXT(Data!Q1:Q20000,"mmm-yy")="Apr-08")*(L1:L20000))

However, you say your dates are Text and not true Excel dates.
You also said in your original post that column C was formatted MM/YY which
would be 04/08

Perhaps you need
=SUMPRODUCT((Data!B1:B20000="ABC Company")*
(Data!Q1:Q20000="04/08")*(L1:L20000))

--
Regards
Roger Govier

"MadWoman" wrote in message
...
OK, now I get a return error of #VALUE! Now what? PS. Column Q is a TEXT
field.

"Roger Govier" wrote:

Hi

=SUMPRODUCT((Data!B1:B20000="ABC Company")*
(TEXT(Data!Q1:Q20000,"mmm-yy"="Apr-08")*(L1:L20000))

--
Regards
Roger Govier

"MadWoman" wrote in message
...
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.