Sumif
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.
|